How to compare columns of 2 different Excel [Solved/Closed]

Report
-
Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
I want to compare column named employeeid
in two different EXcel sheets and have to retrive the rows with same employeeid
ex:
sheet1
emp name empid
x 23
y 67

sheet2

emp name empid
x 23
z 60
y 67

it should find y
can you pls help me

3 replies

Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
This example look like that you want employee ids in sheet 2 which are not in sheet 1.

Supose your employee id is in Column B of both sheet.
now in sheet 2
insert a column next to B,
put formula in C2 as

=VLOOKUP(B2,Sheet1!B:B,1,FALSE)

drag it to last row.

now filter the value #N/A is the employee who are not in sheet 1.

Hope this will helps you.
Thank you so much.. theformula working :)
Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
You are most welcome,

We (Members of the form) enjoy to help you.