vlookup with some conditions

Originally Posted by amotto11

it is not possible in excel to vlookup from right to left

I beg to differ, DDLL came up with a brilliant solution which allows VLOOKUP from right to left

=VLOOKUP("x",CHOOSE({1,2},D2:D10,A2:A10),2,0)