' IF ' + 'AND' condition along with vlookup in python

Hi I to perform below function . How do I do this in python .

If A=Awesome and B=Nice, then do a vlookup from This column else return NA .

How do I do this in python .

basically it in excel it looks like

IF(AND(A=Awesome,B=Nice),vlookup(Cell,sheet1!q-z,2),'NA')