Skip to main content

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

Choose a file

XLSX

* marks required fields.

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.