Avatar of nav2567
nav2567
Flag 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.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Shums Faruk

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
nav2567

ASKER
Sorry, it is not working.  The entire column M shows TRUE.
Shums Faruk

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

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck