Previous Topic Next Topic

How to compare columns of 2 different Excel

Solved/Closed
prathibha - Apr 14, 2011 at 11:50 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 15, 2011 at 01:16 AM
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
Related:

3 responses

Answer 1 / 3
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 15, 2011 at 12:31 AM
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.
Answer 2 / 3
prathibha
Apr 15, 2011 at 01:13 AM
Thank you so much.. theformula working :)
Answer 3 / 3
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 15, 2011 at 01:16 AM
You are most welcome,

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