VLOOKUP
“Get column C from Sheet2 for the ID in A2.”
=VLOOKUP(A2,Sheet2!A:C, 3, FALSE)
Demo mode: the description is not parsed; the formula is built only from the lookup cell, table range and return column you entered.
YOUR FORMULA
Here’s your formula
The first release only supports rightward exact-match VLOOKUP.
Excel
=VLOOKUP(A2,Products!A:C, 3, FALSE)
How it works
A2is the value to find – the product ID.Products!A:Cis the table to search. VLOOKUP always looks in its first column (A).3returns the value from the 3rd column of that table – column C, the price.FALSEmeans exact match only. If the ID isn’t found you get#N/A.
💡 The first release only supports rightward exact-match VLOOKUP.
Example: Products sheet
| A | B | C | |
|---|---|---|---|
| 1 | ID | Product | Price |
| 2 | P-101 | Notebook | $4.50 |
| 3 | P-204 | Stapler | $12.00 |
| 4 | P-318 | Markers | $7.25 |
A2 = P-204 → result $12.00
EXAMPLES
Formulas people ask for every day
Every formula below is real and ready to paste.
Exact match
“Get the price for the product ID in A2.”
=VLOOKUP(A2,Products!A:C, 3, FALSE)
Table range
“Find a value in a bounded table.”
=VLOOKUP(A2,A2:C100, 3, FALSE)
Fixed range
“Keep the table fixed when copying.”
=VLOOKUP(A2,$F$2:$H$100, 2, FALSE)
Multi-letter columns
“Find a value in columns AA to AC.”
=VLOOKUP(A2,AA:AC, 3, FALSE)
Sheet reference
“Search a sheet with a space in its name.”
=VLOOKUP(A2,'My Sheet'!A:C, 3, FALSE)
LOOKUP GUIDE
Build a rightward exact lookup
HOW IT WORKS
Your formula in 3 steps
1Describe it
Write what you want in everyday English. Add cells and ranges if you know them.
2Get the formula
Pick Excel or Google Sheets. We build the right formula and explain each argument.
3Copy & paste
Paste it into your sheet, drag it down, and you’re done.
FAQ
Frequently asked questions
Is the VLOOKUP formula generator free?
Yes. It’s free to use with no account and no sign-up.
What lookups are supported?
The first release only supports rightward exact-match VLOOKUP.
Why does my VLOOKUP return #N/A?
The lookup value wasn’t found in the first column of the range. Check for extra spaces, numbers stored as text, or a range that doesn’t start at the lookup column.
Why does the formula end in FALSE?
FALSE requires an exact match. The first release only supports rightward exact-match VLOOKUP.
Do you store what I type?
Your input is sent to an AI service to generate the formula. We don't store it on our servers.