Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!
VLOOKUP can help you return data from any column in a table based on whatever information is in the first column. The formula is very easy to use and is critical to have in your Excel toolkit. This formula also works in Apple Numbers and Google Spreadsheets.
The formula works like this: =VLOOKUP(Value to look up, Table to search, Column number to return, Should it be a ranged lookup (true) or not (false).