About Excel VLOOKUP
Bring columns from one table into another by matching a shared value such as ID, SKU or email — without writing a formula. Return several columns at once and choose what to show when no match is found.
How to use Excel VLOOKUP
- Upload the main table and the lookup table (or the same file twice with different sheets).
- Pick the matching columns and the columns to bring back.
- Click “Run lookup” and download the result.
Limitations
- Everything runs in your browser’s memory, so the practical file size depends on your device. As a rough guide: up to ~50 MB or ~500,000 rows works well on a modern laptop; phones and tablets handle much less.
- Very large files can make the tab slow or crash. If that happens, split the file first or use a desktop computer.
- Outputs keep values and formulas’ results but not formatting, charts, images, pivot tables or macros.
Frequently asked questions
Can I return more than one column?
Yes, select as many return columns as you like.
What happens when there are several matches?
Choose first match, last match, all matches joined, or the count.
Does the lookup column have to be the first column?
No — any column can be matched, unlike Excel’s VLOOKUP.
Disclaimer: Excel Tools by gumber.ai is a hobby project and is completely free to use. It is provided “as is”, without warranty of any kind. Always double-check results before relying on them, and keep a copy of your original files.
Related tools
Compare Excel Files
Spot changed cells, added rows and removed rows between two versions of a sheet.
Remove Duplicates
Find and remove duplicate rows based on all columns or just the ones you pick.
XLOOKUP / INDEX-MATCH
Look up any column in any direction and return one or many result columns.
HLOOKUP Tool
Lookups for horizontal tables where headers run down the first column.