Generate Excel VLOOKUP formulas with table range and column index. Test lookups against CSV data.
More free utilities you might find useful
Quick answers to common questions
VLOOKUP searches for a value in the first column of a table and returns a value from another column in the same row.
The 1-based index of the column to return. Column A is 1, B is 2, and so on.
Exact match (FALSE) finds an exact value. Approximate (TRUE) requires sorted first column.
Yes. Paste CSV and pick lookup and return columns to see a live test result.
Yes. Copy the generated formula directly into Excel or Google Sheets.
No. Testing runs in your browser.
The test result shows "(not found)" and Excel would return #N/A.
Yes.
Your data is processed entirely in your browser. Nothing is sent to any server.
=VLOOKUP("Bob", A1:D5, 4, FALSE)Test result from CSV: 48000