INDEX #NO MATCH Formula Help

Options

Hello all,

Thank you in advance for any help!

I have the column formula =INDEX({Worker Contacts}, MATCH(Assign@row, {Worker Names}, 0)) that returns contacts for the individuals listed assign column. What can I add to the formula so that #NO MATCH does not appear if the assign column is blank? I want to keep #NO MATCH when the assign column contains names I need to add to my master index list. Any help is very welcome please.

Thank you kindly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!