IF ERROR not fixing #no match

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!