IF ERROR not fixing #no match

Raquel · 10/14/21

Hi- I have an INDEX/MATCH formula inside of an IFERROR to return a blank cell but the cell still says #NO MATCH.

=IFERROR(INDEX({SF Compliance R/F}, MATCH([Primary Column]@row, {User_Alias}, 0)), "")

Any idea how to make the #NO MATCH go away?

Thank you!

Paul Newcome · 10/15/21

Is the error present in the source data?

Paul Newcome · 10/15/21

Is the error present in the source data?

Raquel · 10/15/21

Thank you Paul! I didn't think of that. I added the if error formula to the source file and now I'm all set.

Paul Newcome · 10/15/21

Happy to help. 👍️

Best Answer