troubleshooting Question

Compare Excel spreadsheet - 1

Avatar of nav2567
nav2567Flag for United States of America asked on
Microsoft ExcelMicrosoft Office
3 Comments1 Solution137 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros