Data & Spreadsheets
VLOOKUP Online
Free to useNo sign-up requiredNo watermarkRuns in your browser
This tool does what VLOOKUP does - finds each of your values in another table and copies columns back - but without the formula, the absolute references or the #N/A that never explains itself.
Upload a workbook or two files, choose the column to match on and the columns to bring across, and download the result. Before it runs, it checks the two key columns for the things that quietly break a lookup - trailing spaces, numbers stored as text, invisible characters pasted from a web page - and tells you how many rows are affected.
Useful any time you need to compare Excel data from two sources and find matching values between them - two exports of the same list, a payroll file against an employee master, this month's figures against last month's. Whether the two tables are separate Excel files or two sheets in one workbook, the steps are the same.
How this tool works
Add your spreadsheet
An XLSX, XLS or CSV file. If your two tables are sheets in one workbook, that is all you need; otherwise add the second file as well.
Choose the sheets and the matching columns
Pick the column in your data and the column in the lookup sheet that should line up - the equivalent of the first argument and the lookup range in a VLOOKUP.
Choose what to bring back
Tick every column you want copied across. Unlike VLOOKUP, you are not limited to one, and you do not have to count columns to find its index.
Read the key column check
Any formatting differences that would break the match are counted and shown, with real examples from your file and a preview of what cleaning them up would do.
Run it and download
The result keeps your original rows exactly as they were, with the new columns appended. Download it as an Excel workbook or a CSV.
How it works
Matching happens in three passes, in order. First the values are compared exactly as they are. Anything left over is compared again after cleaning up spacing, capitalisation and invisible characters. Only then, and only if you have asked for it, are close matches considered.
That order matters: a close match can never displace an exact one. If two candidates score almost the same, the row is marked "Needs Review" rather than one being picked for you - a lookup that quietly guesses is worse than one that says it does not know.
Cleaning up a value only affects the comparison. Your original cells are copied into the result untouched, so a sheet matched on a tidied-up key still comes back with exactly the text you started with.
Numbers stored as text are matched against real numbers, because that mismatch is the single most common reason a VLOOKUP fails. Values with a leading zero, such as "007", are deliberately kept as text - merging those with the number 7 would combine two different account numbers.
Everything runs in your browser. The workbook is never uploaded, so there is no file size limit imposed by a server and no copy of your data anywhere else.
Why a VLOOKUP returns #N/A when the values look identical
Almost always, the two values are not identical - they only look it. A trailing space, a non-breaking space pasted from a web page, or an invoice number stored as text on one sheet and as a number on the other will all defeat an exact comparison while appearing the same in the cell.
This tool counts each of those problems before it runs and shows you examples from your own file, so you can see the cause rather than guessing at it.
What the result contains
| Result | Your original rows, with the columns you chose appended |
|---|---|
| Match Summary | How many rows matched, by method, and the settings used |
| Unmatched | Rows that found nothing, so you can chase them |
| Needs Review | Rows where two candidates scored too closely to choose |
| Duplicates | Rows whose key appeared more than once in the lookup sheet |
Differences from Excel VLOOKUP
- You can return several columns at once, rather than one per formula.
- The lookup column does not have to be the leftmost column of the range.
- There is no approximate-match mode that silently returns the wrong row. Close matching is separate, off by default, and always reported.
- Duplicate keys are flagged rather than silently resolved to the first hit.
Frequently asked questions
Is this VLOOKUP tool free?
Yes, with no sign-up and no limit on how many lookups you run.
Is this an online VLOOKUP calculator?
It is an online VLOOKUP tool rather than a calculator in the strict sense - there is no single formula result to compute, since a lookup usually brings back several columns across many rows at once. Think of it as doing what VLOOKUP does, in your browser, without the formula.
Is my spreadsheet uploaded anywhere?
No. Your files stay on your device. The workbook is read and processed by your browser, so nothing is uploaded, stored or logged - which matters when the sheet holds customer records, invoices or payroll.
Can I look up between two separate files?
Yes. Turn on "The lookup table is in a separate file" and add the second workbook. You can also match between two sheets of the same workbook, which is the more common case.
Why did my VLOOKUP return #N/A in Excel but match here?
Because the values differed by something invisible - usually a trailing space, a non-breaking space or a number stored as text. This tool compares again after normalising those, and tells you how many rows it affected.
Can I return more than one column?
Yes. Tick as many columns as you need and they are all appended, in the order you chose them.
What happens if the lookup sheet has the same key twice?
The row is marked "Duplicate Key" and the first match is used, exactly as Excel would - but you are told it happened, and the affected rows are listed on their own sheet.
What is the largest file I can use?
There is no server limit because nothing is uploaded. The practical ceiling is your device's memory; workbooks beyond about two million cells are refused rather than being allowed to freeze the tab.
Guides for this tool
How to match two spreadsheets without writing a formula
Need to pull columns from one Excel file into another? Match two spreadsheets in your browser with VSThiran - click the two columns to match on, no VLOOKUP formula required.
Excel names don't match? Find similar records with fuzzy matching
Company or customer names differ slightly between two spreadsheets? Use VSThiran's fuzzy matching to find records that are similar even when the text isn't identical - like "ABC Trading LLC" and "ABC Trading L.L.C."
How to clean messy Excel data without writing formulas
Spreadsheet full of inconsistent spacing, casing and formats? Clean it up in your browser with VSThiran - trim spaces, fix casing, standardise dates and numbers, drop blank rows.
What's actually in this spreadsheet? Check before you build on it
Inherited a spreadsheet and not sure what's actually in it? Profile it in your browser with VSThiran - see what each column holds, what's missing, and where the problems are before you rely on it.