Excel VLOOKUP Tool
Match and merge data from multiple Excel files
New here? Try with sample data
We'll load two sample Excel files — Employee Master (15 rows) and Salary Data (13 rows) — so you can see how VLOOKUP works instantly.
File A (Main Data)
Your base data file
File B (Lookup Data)
Data to look up and merge
How VLOOKUP Works
Powerful Features
Smart Matching
Choose from Exact, Contains, Starts With, or Ends With match types for flexible data matching.
Case Control
Toggle case sensitivity for precise control. Match "ABC" with "abc" or treat them as different values.
Duplicate Detection
Automatically detects duplicate keys in your lookup file and warns you before processing.
Unmatched Handling
Control what happens when no match is found: leave blank, show #N/A, custom text, or remove the row.
Comparison Analysis
See matched rows, rows only in File A, rows only in File B — with visual summary and match percentage.
Multi-Sheet Export
Download results as multi-sheet Excel with Merged, Matched, Only in A, Only in B, and Summary sheets.
Common Use Cases
Add Employee Details
Match employee IDs to add names, departments, salaries
Product Information
Add product details to order data by SKU
Price Lists
Match product codes to add pricing information
Data Enrichment
Combine data from different sources
How It Works
Upload Files
Main file + Lookup file
Select Keys
Choose matching columns
Configure
Set match options
Download
Edit and export
Frequently Asked Questions
What is VLOOKUP?
VLOOKUP lets you find and add data from one file to another using a matching key column. For example, add salary data to an employee list by matching Employee IDs. Our tool also shows which rows matched, which are only in File A, and which are only in File B.
Can I try the tool without my own files?
Yes! Click "Try with Sample Data" to instantly load two pre-built Excel files (Employee Master + Salary Data). This lets you explore all features — matching, comparison tabs, and multi-sheet export — without uploading anything.
What comparison analysis does the tool provide?
After VLOOKUP, you get tabbed results: All Results (merged data), Matched (rows in both files), Only in File A (missing from B), Only in File B (missing from A), and a Summary with visual charts and match percentage.
What match types are supported?
Four match types: Exact Match (values must be identical), Contains (partial match), Starts With (main value begins with lookup value), and Ends With (main value ends with lookup value).
Can I download the comparison results?
Yes! "Download All (Multi-Sheet)" creates an Excel file with separate sheets for Merged Results, Matched, Only in File A, Only in File B, and Summary. Or download just the merged results.
Can I edit results before downloading?
Yes! The result table is fully editable. Click any cell to modify its value, add new rows, or delete rows. All changes are included in the download.