Returning specific words when no match on index formula


I have the below formula that works when data is entered on the index sheet, what i would like to achieve is instead of #NO MATCH when data is not present, the words "Awaiting Data" Current formula is:

=INDEX({Angela shift patterns managed by}, MATCH(Store@row, {Angela shift patterns store names}, 0))

I have read a lot about if error but cannot get my head around what to do.

Any help would be appreciated.

Thank you


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!