Thread: If value in column a = respective row in column b

EXCEL 2007

in my dropdown sheet - I have a list of VRT environments - which I use for a dropdown list on my calculator sheet in cell e37.

I need k35 on my calculator sheet to give me the respective VRT Reaction time on the dropdown list. For example:

if 'calculatorE37' = "simple environment" I need k35 to be "8".

and if 'calculatore37' is empty - then I need k35 to be " "

I've tried: =IF(E37=DROPDOWNS!A2:A5,DROPDOWNS!C2:C5," ")

Thank you!

Please check the attached file.

Sorry, please use this =IF(E37<>"",VLOOKUP(E37,DROPDOWNS!$A$1:$C$5,3,0),"")