Sign In


Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!



Lookup Data From a Table Using VLOOKUP in Excel


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


Tutor Bio

Alternative Text

In real life Mike is a husband and father of 2. He also develops websites (like this one) and makes overwhelming amounts of data understandable using Excel, Numbers, Access, etc.