Previous Topic Next Topic

How to compare columns of 2 different Excel

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

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

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