VLOOKUP in Excel - A Simple Example

Some VLOOKUP examples try to demonstrate every possible feature at once, which can make the core idea harder to follow rather than easier. This page uses a deliberately small, simple product list with just three rows, so each of the four arguments can be traced without distraction.

Once this simple version makes sense, applying the same pattern to a larger, real spreadsheet is mostly a matter of adjusting the range.

Three products, four columns - nothing more:

To find the Price of SKU-2201:

That's the whole formula. "SKU-2201" is what to search for, A2:D4 is where to search, 4 is which column to bring back, and FALSE means it has to match exactly.

A good way to build confidence is to change one argument at a time and observe the result. Changing the lookup_value to "SKU-2203" returns 150 instead of 699. Changing col_index_num from 4 to 3 returns the Category instead of the Price for the same product.

There's no sorting requirement, no approximate matching, and no multi-sheet references involved - just a flat table and an exact-match lookup. That's intentional, since those additions are worth learning only after the basic four-argument pattern is second nature.

The moment this same lookup needs to run against dozens of SKUs instead of three, or against two separate files, Turbo Excel VLookup handles that scale-up automatically - the underlying matching idea stays exactly this simple, but it runs across the whole dataset at once.

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.