How to Use VLOOKUP - Simple Example

This is a compact guide focused on one thing: using VLOOKUP correctly the first time, with a simple example that shows exactly why each argument is set the way it is. It uses a small warehouse inventory table, but the logic applies to any two-column matching problem.

Once this simple pattern is clear, it's the same pattern behind almost every VLOOKUP formula you'll ever write.

To find the Warehouse for ITM-03:

Item codes are unique identifiers, so an approximate match makes no sense here - FALSE forces Excel to find an exact match or return #N/A rather than confidently returning the wrong item's data.

1. Confirm the lookup value matches exactly, including capitalization and spacing.
2. Confirm table_array starts at the ID column, not somewhere to its right.
3. Recount col_index_num from the start of table_array, not from the worksheet's column headers.
4. Confirm range_lookup is FALSE if an exact match is required.

The same formula pattern works on a table with thousands of rows - only table_array needs to expand to cover them. For matching an entire inventory list against another file without writing or copying formulas, Turbo Excel VLookup performs the same match across the whole dataset in one step.

A surprising number of VLOOKUP problems turn out to be a data type mismatch rather than a logic error - a value stored as text in one column and as a number in the other will never match, even if they look identical on screen.

Before assuming the formula itself is wrong, select the lookup value's cell and check the small green triangle or the number alignment; numbers align right by default, and text aligns left, which is a fast way to spot the mismatch.

In a shared workbook, a bare VLOOKUP formula gives the next person no indication of what it's supposed to be matching or why. Adding a cell comment, or a short label in an adjacent column, explaining the source and purpose of the lookup saves significant time when the workbook is revisited months later or handed to a colleague.

This becomes even more important once a workbook has several lookups feeding into each other, since untangling a chain of undocumented formulas is far harder than reading a documented one.