How to use VLOOKUP in Google Sheets on Mac: a browser walkthrough with fixes

What VLOOKUP does in Google Sheets

VLOOKUP does one job. You give it a value, and it finds that value in a list. Then it returns a related value from the same row. Think of a product code on one sheet and the product name you want on another.

The function searches the first column of the range you select. It moves down the rows until it finds a match. Then it returns the value from the column number you chose. Google's help page says VLOOKUP only returns the first match, so duplicates matter.

Google's help page lists the syntax as VLOOKUP(search_key, range, index, is_sorted). The table below explains each part in plain words.

Set up your data before you type

Your lookup column must be the first column of the range. VLOOKUP never looks left. If product codes sit in column C and names sit in column A, the formula cannot find the codes. Move the column first, or use a different formula.

Keep the data clean. Google's help page says wildcards need an exact match, and it advises trimming extra spaces. It also says to store numbers and dates as numbers, not text. A code stored as text will not match the same code stored as a number.

For this guide, the product list sits on a sheet named Prices. Column A holds the product code, column B holds the product name, and column C holds the supplier. The Orders sheet has product codes in column A.

A worked example you can copy

On the Orders sheet, put a product code in cell A2. Then click cell B2 and type this formula:

=VLOOKUP(A2, Prices!A2:C5, 2, FALSE)

Read it in plain words. Take the code in A2. Find it in the first column of Prices, from row 2 to row 5. Return the value from the second column of that range, using an exact match.

Google's own example works the same way. The help page shows =VLOOKUP("Orange", B4:D8, 3, FALSE) returning $1.01 from its sample table. Your numbers will differ, but the logic is the same.

When B2 shows the right name, the formula works. The next sections make it safe to copy down the column.

Why FALSE matters for exact matches

The fourth argument controls how the search works. FALSE means exact match, and Google's help page recommends it. If you leave the argument out, Sheets uses TRUE. TRUE expects the lookup column sorted in ascending order.

A sorted search can return a wrong answer with no error. It stops on a row that looks close enough. That is the mistake that hurts most, because the result looks normal. Type FALSE every time unless you have a clear reason not to.

Lock the range so the formula copies correctly

Copy the formula down and the range moves with it. Row 3 would search Prices!A3:C6, and the match would miss. Lock the range with dollar signs so it stays fixed.

The formula becomes =VLOOKUP(A2, Prices!$A$2:$C$5, 2, FALSE). The search key A2 stays relative, so it moves down one row at a time.

On a Mac, click inside the range in the formula and press Fn+F4. Each press cycles the dollar signs. Then select B2 and the cells below it, and press ⌘D to fill down.

When you cannot find the menu item

You can insert the function from the menu. Click the result cell, then choose Insert > Function > Lookup > VLOOKUP. The Google help pages I checked do not show this exact path, so treat it as a guide, not a guarantee.

Menu labels change between Sheets updates. If you cannot find the item, press Option+/ to open the Tool finder. Type VLOOKUP, then pick the function from the results.

Keyboard shortcuts for VLOOKUP on Mac

Google lists these shortcuts for Sheets on a Mac. Some keys need the Fn key, because the top row of a Mac keyboard controls brightness and volume by default.

Google's list shows Show all formulas as Ctrl+~ on Mac. That is unusual, so press it once on your own keyboard before you rely on it.

Fix the #N/A error in VLOOKUP

The most common result is #N/A. It means the formula found no match. Google's help page says so, and it suggests wrapping the formula in IFNA.

This version shows a readable message instead: =IFNA(VLOOKUP(A2, Prices!$A$2:$C$5, 2, FALSE), "Not found"). The lookup still fails. The message just makes the gaps easy to spot.

Mistakes that give wrong answers without errors

• Missing FALSE. Sheets assumes TRUE, and the formula may return a close but wrong row.
• Extra spaces. A code with a trailing space will not match the same code without one. Trim the search key or clean the column.
• Numbers stored as text. Numbers that sit left-aligned in a cell are often text. Convert them before you search.
• Duplicate codes. VLOOKUP only returns the first match. A second row with the same code never appears.
• Wildcards without FALSE. Google's help page says wildcards need an exact match. Keep FALSE if you use * or ?.
• Ranges that shift. A range without dollar signs moves when you copy, and the lookup reads the wrong rows.

Duplicates are the hardest mistake to spot, because nothing looks broken. Check the lookup column for repeats first. Then read how to remove duplicate rows in Google Sheets on Mac before you trust the results.

Test the formula before you copy it

Pick three codes whose answers you already know. Type them into the search cells and check each result by eye. If all three match, you can copy the formula down with confidence.

If one fails, check the spacing first. Then check whether the code is text or a number. Only after that should you look at FALSE, the range, or the column number.

When VLOOKUP is the wrong tool

VLOOKUP cannot look left, and it returns only one match. If you need the value on the left, or every match, you need a different formula. Google's product page says Gemini in Sheets can write and explain formulas, and help fix formula errors.

Gemini is a useful second opinion. Ask it to explain your error, then check any formula it suggests against your own sheet before you paste it in.

Where to go next

Sort the lookup table if you use TRUE. Freeze the top row so headers stay visible when the table is long. Read how to sort data by column in Google Sheets on Mac and how to freeze the top row in Google Sheets on Mac.

If your data comes from a file, read how to import a CSV file in Google Sheets on Mac. The formula steps here stay the same once the data is in.

Lazur runs on macOS, on both Apple silicon and Intel Macs. Hold ⌥ ⌘ and ask where the Insert menu is, and Lazur circles it. Pricing starts with a free trial that needs no credit card, see pricing.