Switching from Excel to Apple Numbers raises one immediate question: does Numbers have VLOOKUP? Yes — the same lookup function exists, with the same logic and nearly the same syntax. If your system language is Russian, you will meet it under the name ВПР, but the way it works is identical. Here is how to use it.
What VLOOKUP does
VLOOKUP searches the first column of a table for a value you specify, then returns the contents of a cell from the same row in a column you choose. It is the classic tool for jobs like finding a product’s price from its code or an employee’s department from their ID — one formula that saves you from scrolling through hundreds of rows.
The syntax
In Numbers the function looks like this:
=ВПР(lookup_value; table_range; column_number; exact_match)
The arguments are separated by semicolons in locales that use the comma as a decimal separator. In English-language setups you will more often see =VLOOKUP(A2, B2:D10, 3, FALSE) with commas — the logic is the same either way.
Build the formula step by step
- Click the cell where the result should appear. This is where the looked-up value will land.
- Type
=and start the function name. TypeВПР(— orVLOOKUP(in an English locale. Numbers’ formula editor will offer to autocomplete the function; press Tab to accept it. - Enter the first argument: the value to find. Click the cell that holds your lookup value (for example
A2), or type the value directly in quotes. This is the needle you are searching for. - Enter the second argument: the table range. Select the whole table, making sure the column that contains the lookup values is the leftmost column of your selection (for example
B2:D10). VLOOKUP only ever searches the first column of the range you give it — this is the single most common source of errors. - Enter the third argument: the column number. Count from the left edge of your range, starting at 1. If your range is
B2:D10and you want the value from column D, the number is3— not the spreadsheet’s column letter. - Enter the fourth argument (optional): the match type. Use
0(or FALSE) for an exact match, which is what you want in nearly all cases. Use1(or TRUE) only for an approximate match on data that is sorted in ascending order, such as tax brackets. - Close the bracket and press Return. A complete example looks like
=ВПР(A2;B2:D10;3;0): find the value from A2 in the first column of B2:D10 and return the exact match from the third column of that range.
If it still doesn’t work
Nine times out of ten, a failing VLOOKUP means one of three things: the lookup column is not the leftmost column of the range, there are invisible extra spaces in the lookup values, or the match type is wrong for unsorted data. Check those first. Apple’s Numbers formula reference documents every argument in detail, and MacRumors has long threads on migrating Excel workflows to Numbers. And if you are still getting comfortable with macOS itself, learning to open the installed apps list quickly and change folder colors and add emoji will make the whole system feel more familiar.
FAQ
Why does my formula show an error instead of a result?
Most often the lookup value simply is not found in the first column — check for typos and trailing spaces. With exact match (0), even a single extra space means “not found.”
Can VLOOKUP look to the left?
No. It only searches the leftmost column of the range and returns values to the right of it. To look leftward, rearrange your columns or use INDEX combined with MATCH instead.
Wrapping up
VLOOKUP in Numbers works exactly like its Excel counterpart: point it at a value, a table, a column number, and a match type, and it does the searching for you. Master the argument order once and you will use it in every spreadsheet you build.
