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)
Thursday, January 9, 2020
Reverse or Backward Vlookup in Microsoft Excel
Subscribe to:
Posts (Atom)