Use Excel's VLOOKUP function to find anything on a table

[Windows Central]

Do you work with a large spreadsheet or always look for the same data in a table? Then you should use the VLOOKUP function in Excel to make your life easier, and here's how.
In Microsoft Excel, VLOOKUP (vertical lookup) is a useful search function that allows you to find any information within a table range by looking at the first column of data and returning a related value from another column on the right.

Full story from the WindowsCentral blog...