INDEX MATCH needs to pull blank if there's nothing in the cell

Siobhan16

I'm currently writing a formula to pull the data from one sheet to another. My formula pulls the data in if there's information in the cell. If there's nothing in the cell it returns "#NO MATCH". How do I get it to return nothing if there's nothing there instead of NO MATCH?

Here's my current formula-

=(INDEX({RPA Last Name}, MATCH([Row ID]@row, {RPA ID}, 0)

Paul Newcome

You need an IFERROR

=IFERROR(original_formula, "")

Zachary Hall

@Siobhan16

Try:

• IFERROR(INDEX({RPA Last Name}, MATCH([Row ID]@row, {RPA ID}, 0)),"")