Comparing one sheet to another in excel Closed

Question

Hello,

i am fimilar with the vlookup function, however I have one question. I know how to match one column from sheet1 to another column in another sheet. How do I match two columns from one sheet to two columns in another sheet?

ex:
sheet one: name and dob
sheet two: name and dob

the formula I am using is =IF(ISERROR(VLOOKUP(C2,Sheet3!C:C,1,FALSE)),"NO","YES")

c2= Names
d2= DOB
this is where I am confused I want to add D2 so I can compare both columns to sheet 2

Let me know as soon as you can

rizvisa1 · Answer

I guess you are trying to compare both columns at the same time, i.e, find a match where name and DOB matches. 

The most easy way would be if you could add one additional column in Sheet3


Lets say on Sheet3, you have DOB in Column D and Name in column C

If you can add a new column at E location of sheet 2 and have it populated with formula
=C1 & "|" & D1   (just drag it down to last row)

In in sheet 1 where you are doing look up, you can say

=IF(ISERROR(VLOOKUP(C2 & "|" & D2 ,Sheet3!E:E,1,FALSE)),"NO","YES") 

Would this work for you

B · Answer

I have tried that before but it loses it format I have tried to format it mmddyyyy, yyyymmdd (dob field) and it still does not show the correct DOB. What em I doing wrong?

B · Answer

my company does not a site to share our files but if you want, can you send me your email address so I can send you what I have.

Comparing one sheet to another in excel

3 responses

Subscribe To Our Newsletter!