Peggy Parchert

I created two sheets: Bad Sheet and Good Sheet with ID columns. I then added a Helper column to the Good Sheet and put in this formula:

=IFERROR(IF(INDEX({Bad Sheet ID}, MATCH(ID@row, {Bad Sheet ID}, 0)) = ID@row, “Yes”, “No Match”), “No Match”)

I made the Helper column a column formula column.

This formula checks if the current row’s ID appears in a range call {Bad Sheet ID} – confirming if it matches exactly.

Step-by-Step:
1. MATCH(ID@row, {Bad Sheet ID}, 0)
1.1 Searches for the current row’s ID in the {Bad Sheet ID} range
1.2 0 means exact match only
1.3 Returns the row number where the match is found (if found)

2. INDEX({Bad Sheet ID}, MATCH(…))
2.1 Uses that row number to return the matching value from {Bad Sheet ID}
2.2 Basically saying: “Give me the ID from the sheet where this row matches”

3. Compare:
3.1 Checks if the result equals ID@row
3.2 If yes → “Yes”
3.3 If not → “No Match”

4. IFERROR(…, “No Match”)
4.1 If the MATCH() fails (i.e., the ID isn’t found), returns “No Match” instead of an error

Hopefully this helps.