VLOOKUP Formula Generator
A VLOOKUP looks up a value in the first column of a range and returns a value from a column to its right. This free generator writes the exact formula for you — just fill in the four inputs below and copy the result. It works identically in Microsoft Excel and Google Sheets.
Everything runs in your browser. Nothing is uploaded, and you don't need an account.
=VLOOKUP(E2, A2:C100, 3, FALSE)
=XLOOKUP(E2, A2:A100, C2:C100, "Not found", 0)
VLOOKUP syntax explained
The formula is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
lookup_value is what you're searching for. table_array is the range that contains your data — the lookup column must be the leftmost column of this range. col_index_num is the position (counting from 1) of the column whose value you want to return. range_lookup is FALSE for an exact match (recommended) or TRUE for an approximate match on sorted data.
Common VLOOKUP mistakes to avoid
Forgetting FALSE: omitting the last argument defaults to an approximate match, which silently returns wrong values on unsorted data. Almost always use FALSE.
Counting columns wrong: col_index_num counts columns within table_array, not the worksheet. If your range starts at column C, the first column is 1, not 3.
The lookup column isn't leftmost: VLOOKUP can only look right. If the value you want is to the left of your key, use XLOOKUP or INDEX/MATCH instead.
Frequently asked questions
What is the VLOOKUP formula syntax?
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Use FALSE as the last argument for an exact match.
Does VLOOKUP work in Google Sheets?
Yes. VLOOKUP has identical syntax in Google Sheets and Microsoft Excel, so the formula this tool generates works in both.
Should I use VLOOKUP or XLOOKUP?
Use XLOOKUP when it's available (Excel 365 and Google Sheets). It can look left as well as right, doesn't break when columns are inserted, and has cleaner syntax. VLOOKUP remains useful for older Excel versions. This tool shows you both.
Why does my VLOOKUP return #N/A?
#N/A means the lookup value wasn't found. Common causes: extra spaces, a number stored as text, or using an exact match (FALSE) when the value truly isn't present. Wrap it in IFERROR to show a friendly message.
Keep exploring
Analyze a whole spreadsheet with AI
Upload an Excel or CSV file and get pivots, outlier detection, and Smart BI dashboards in seconds. Free to start — no credit card.
Open the App Free