Find product data
Return product names, prices, and categories by matching an SKU or product code.
Spreadsheet utility
VLOOKUP Formula Generator
VLOOKUP still matters because many live spreadsheets depend on it. This page is for legacy compatibility, exact-match discipline, and faster correction of the arguments that usually go wrong.
Use this page when the workbook already relies on VLOOKUP or you need the classic first-column lookup structure instead of a newer lookup pattern.
Exact-match friendlyArgument guidance built inWorks for Excel and Sheets
Overview
Why VLOOKUP still deserves its own landing page
VLOOKUP is older than XLOOKUP, but it still appears in countless active spreadsheets. That means users often need help writing or repairing VLOOKUP even when they know there are cleaner modern options.
This page focuses on the classic lookup pattern itself: first-column matching, column-index logic, and exact-match settings that are easy to miss but costly to get wrong.
How to use it
How to describe a VLOOKUP request without missing the risky arguments
Step 1
Describe what value you want to find and what result you want returned.
Step 2
Choose Excel or Google Sheets based on your file.
Step 3
Copy the formula, then verify the table range and return column before using it broadly.
Use cases
Where VLOOKUP is still the right fit
Map customer records
Find customer tiers, account managers, or status labels from a reference table.
Validate imports
Match IDs after importing data from another system and fill in missing attributes.
Practical examples
Classic VLOOKUP patterns you can adapt quickly
These examples focus on the traditional VLOOKUP structure: lookup value, table range, return column, and exact match.
Find customer name
Prompt: Find customer name by ID in columns A:C
Example formula
=VLOOKUP(A2,$A:$C,2,FALSE)Searches for the ID in A2 within the first column of A:C and returns the matching customer name from column B.
Return price
Prompt: Return price from column D based on product code in A2 using range A:D
Example formula
=VLOOKUP(A2,$A:$D,4,FALSE)Looks up the product code in A2 inside column A and returns the matching price from the fourth column in the range.
Department lookup
Prompt: Look up department by employee ID in table F:H
Example formula
=VLOOKUP(A2,$F:$H,3,FALSE)Matches the employee ID against the first column in F:H and returns the department value from the third column.
Status by exact match
Prompt: Return status from column 3 using exact match
Example formula
=VLOOKUP(A2,$F:$H,3,FALSE)Uses FALSE to force an exact match so the returned status is not based on a loose approximation.
What VLOOKUP does
Why VLOOKUP still matters in production spreadsheets
Many spreadsheet teams still maintain files built around VLOOKUP. In those environments, the immediate job is not to debate the perfect modern function. It is to write the VLOOKUP correctly and make sure it does not return the wrong row or column.
This page keeps the classic argument order visible so you can move faster in real workbooks that already depend on the function.
Common mistakes
Why VLOOKUP often returns the wrong value even when it looks close
The lookup value has to exist in the first column of the selected range. If it does not, the formula will not behave the way most people expect.
Another common mistake is using the wrong return column number. If the range starts in column B instead of A, the column index still starts counting from the first column inside the selected range, not the worksheet itself.
- Wrong lookup range
- Wrong return column number
- Approximate match when exact match is needed
- Lookup value not in the first column of the range
When to move on
Know when XLOOKUP is the cleaner new default
VLOOKUP is still useful because it is familiar and widely supported, but it is not always the best long-term choice. If your environment supports XLOOKUP, it is often easier to read and less fragile when table structures change.
This page still matters because many real spreadsheets use VLOOKUP today, and people need help writing and fixing it quickly.
FAQ
Frequently asked questions
What is VLOOKUP used for?
It searches for a value in the first column of a range and returns a related value from another column in the same row.
When should I keep VLOOKUP instead of switching to XLOOKUP?
Keep VLOOKUP when the workbook already uses it heavily, when compatibility matters, or when you are working inside a file that other users still expect to stay in the classic pattern.
Does this work for Excel and Google Sheets?
Yes. VLOOKUP exists in both, although many users now prefer XLOOKUP when it is available.
When should I use XLOOKUP instead?
If your spreadsheet supports XLOOKUP, it is usually more flexible and easier to maintain than VLOOKUP.
Why does my VLOOKUP return the wrong value?
The usual causes are a bad range, the wrong column index, approximate matching, or lookup values that are not actually in the first column of the range.
Can this tool explain each argument?
Yes. The page is designed to make the lookup value, table range, column index, and match mode easier to understand.
Next pages
Need the cleaner modern lookup pattern instead?
Stay here when you are working inside existing VLOOKUP-heavy files. Move to XLOOKUP when the workbook supports it and you want explicit return ranges instead of column indexes.
XLOOKUP Formula Generator
Create modern lookup formulas with explicit return ranges and custom not-found logic.
Excel Formula Generator
Start from a plain-English task and get a full Excel formula you can adapt.
Google Sheets Formula Generator
Build Google Sheets formulas with Sheets-first syntax and shared-sheet workflows in mind.
Formula Examples
Browse copy-ready reference formulas before generating something more custom.