Reverse or Backward Vlookup in Microsoft Excel

Reverse or Backward Vlookup in Microsoft Excel

Following is the data format we have.

• We will use VLOOKUP and CHOOSE function.
• In cell F2 formula
• =VLOOKUP(E2,CHOOSE({1,2},C2:C5,A2:A5),2,FALSE)