You may choose to restructure your table to meet this requirement. How to Do a VLOOKUP in Excel Now that you know how Excel's VLOOKUP works, using it is just a matter of choosing the right arguments.

An curved arrow pointing right. VLOOKUP is one of the most useful functions in Excel. You can pull specific data out of huge data sets with a simple formula. Just watch. Produced by Sara ...

The benefit of a last-to-first lookup is that you can find the most recent occurrence of a value in a lookup array that is ...

An curved arrow pointing right. Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP.