FG
💻 Software

Merge two excel files using a common column

Fresh5 days ago
Mar 15, 2026278980 views
Confidence Score0%
0%

Problem

I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg. Notice that in the first column of the 2nd excel, 2 is missing, so I want the first excel to look like this, I am new to excel. Any help on this will be highly appreciated.

Error Output

The first excel,    the 2nd excel

1  t                 1   tes1
2  5                 3   tes3
3  t                 4   tes4
4  g

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Merge two excel files using a common column

Low Risk

I have placed the data from "the first excel" on Sheet1, and "the 2nd excel" on Sheet2. The key to this solution is the VLOOKUP() function. First we insert a column. We then use the VLOOKUP() function to lookup the value of "1" in Sheet2. We specify…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment