Excel VLOOKUP
Search for values in an Excel file and find matching values from other columns.
- Processed on the server
- No sign-in needed
Excel file and lookup criteria
Search Result
Upload an Excel file, enter the criteria and press [Search] — the found value appears here.
How to use Excel VLOOKUP
When to use
Use to search for a value in one column of an Excel table and get the value from another column in the same row, without the VLOOKUP formula.
What to input
Upload one Excel file (.xlsx, up to 30MB) and enter the column to search, the column to return, and the value to search for. Enter column names exactly as they appear in the first row.
Usage example
e.g. Enter Name as the column to search, Email as the column to return, and John Doe as the value, and the email in John Doe's row is shown on screen.
Things to check
Values must match exactly - differences in spaces or letter case are not found, and if the value appears in several rows only the first is shown. It does not join tables or create a result file.
Related tools
Remove duplicates, empty rows/columns, and stray whitespace to get analysis-ready data.
No sign-in neededProcessed on the server
Create pivot tables to summarize and analyze your data.
No sign-in neededProcessed on the server
Extract a sheet, merge several Excel files into one, split a workbook by sheet, or remove duplicate rows.
No sign-in neededProcessed on the server
Uploaded files are used only for the requested job, and temporary files are deleted automatically afterwards.