Comparing one sheet to another in excel

Closed
B - Mar 10, 2010 at 02:39 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 12, 2010 at 02:29 PM
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

3 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 12, 2010 at 01:58 PM
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
1
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?
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 12, 2010 at 02:15 PM
Guess put your file at a share site so that one can have a look.
0
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.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 12, 2010 at 02:29 PM
Would you be able to put at https://authentification.site

I have been asked not to give email address at the forum by Gods of this forum
0