Index Match

Adarian Searcy

I am attempting to eliminate the #No Match in my formula for the "Duplicate" column. If the return is no match leave cell blank and if the Zip column is blank leave the Duplicate column blank as well.

Current Formula: =INDEX({Safety Zones Production Range 2}, MATCH(Zip@row, {Safety Zones Production Range 1}, 0)), works with a responding answer that matches and is correct.

I tried IFERROR formula but received a "Syntax isn't right" message.

Michelle Choate 2

You are missing a Comma.

Try This:

=IFERROR(INDEX({Safety Zones Production Range 2}, MATCH(Zip@row, {Safety Zones Production Range 1}, 0)),"")

Michelle Choate 2

You are missing a Comma.

Try This:

=IFERROR(INDEX({Safety Zones Production Range 2}, MATCH(Zip@row, {Safety Zones Production Range 1}, 0)),"")

Adarian Searcy

@Michelle Choate 2, this worked, thank you for your assistance! 😁