Match Names on Two Sheets, return True or False

0
votes

Spent a long time searching hoping to find this, but everything I see is trying to fetch other data with VLOOKUP. Since I just need a count of matches, I just need it to return True or False.

Two Sheets named 'X' and 'Y'. Trying to match Column A "FirstName" and Column B "Last Name"

For example, if someone on Sheet B is name John Smith, I need to see if someone on Sheet A is also named John Smith (with both names being on the same row). If so, return true.

1
excelformula

1 Answers

0
votes
=COUNTIFS(X!A:A, "John", X!B:B, "Smith")>0

Unless there's more to it that I didn't catch.

You can replace "John" and "Smith" with the addresses of the cells containing the names to search.