Spreadsheet
VLOOKUP Calculator
Generate Excel VLOOKUP formulas with table range and column index. Test lookups against CSV data.
Generated formula
=VLOOKUP("Bob", A1:D5, 4, FALSE)Test result from CSV: 48000
Sample data (CSV)
Related Tools
More free utilities you might find useful
Frequently Asked Questions
Quick answers to common questions
What does VLOOKUP do?+
VLOOKUP searches for a value in the first column of a table and returns a value from another column in the same row.
What is column index?+
The 1-based index of the column to return. Column A is 1, B is 2, and so on.
Exact vs approximate match?+
Exact match (FALSE) finds an exact value. Approximate (TRUE) requires sorted first column.
Can I test against real data?+
Yes. Paste CSV and pick lookup and return columns to see a live test result.
Is the formula Excel-compatible?+
Yes. Copy the generated formula directly into Excel or Google Sheets.
Is my data uploaded?+
No. Testing runs in your browser.
What if the value is not found?+
The test result shows "(not found)" and Excel would return #N/A.
Is it free?+
Yes.