Returning specific words when no match on index formula

dave.mcpherson56751

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

Andrée Starå

Hi Dave,

You’d use IFERROR for this.

Try something like this.

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

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Dave,

You’d use IFERROR for this.

Try something like this.

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

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

dave.mcpherson56751

Hi Andree,

works perfectly, thank you as always.

Have a lovely weekend

Dave

Andrée Starå

Excellent!

Happy to help!