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.