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 ...

One function that anyone looking to master the spreadsheet program needs to know is VLOOKUP. It's easily one of the handiest ways to sort through and understand large reams of data. Here ...

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.