Link to home
Start Free TrialLog in
Avatar of nav2567
nav2567Flag for United States of America

asked on

Compare Excel spreadsheet - 1

I have 2 spreadsheets in the same workbook.

In spreadsheet 1, column B and C, I have list of user First and Last Names:

First Name      Last Name
John            Doe
Mary            Dawson
Rob                    Cool
Ivan            Dyals


In spreadsheet 2, column K and L, I have list of user First and Last names:

First Name      Last Name--->this is in row 2
Mary            Dawson
Anthony            Fusco
Jack                    Palermo
Rob                    Cool
....

I want to column M of spreadsheet 2 to show MATCH if name is found in spreadsheet 1:

First Name      Last Name
Mary            Dawson            MATCH
Anthony            Fusco            
Jack                    Palermo            
Rob                    Cool            MATCH
....

I am using the below similar to what another expert suggests in M3 of spreadsheet 2 but it is not working.  

=IF(ISERROR( MATCH(L3 & ", " &K3,Sheet1!F:F,0) ), "", "Match")

Please advise in this ticket.  Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nav2567

ASKER

Sorry, it is not working.  The entire column M shows TRUE.
Hi,

Try below:
=IF(OR(COUNTIF(K:K,K2)=COUNTIF(Sheet1!B:B,K2),COUNTIF(L:L,L2)=COUNTIF(Sheet1!C:C,L2)),"Match","")

Open in new window