Returning specific words when no match on index formula

Hi,

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

Dave


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!