Help with IFERROR

SEBERCAW · 08/04/22

This formula works until I add the IFERROR and the parenthesis before the word INDEX and after the last )

=IFERROR(INDEX(COLLECT({EEO/HARRASSEMENT}, {NAME}, NAME@row, {EEO/HARRASSEMENT}, <>""), 1))

Paul Newcome · 08/04/22

You need to tell it what to output if there is an error.

=IFERROR(INDEX(COLLECT({EEO/HARRASSEMENT}, {NAME}, NAME@row, {EEO/HARRASSEMENT}, <>""), 1), "what gets output in the event of an error")

Paul Newcome · 08/04/22

You need to tell it what to output if there is an error.

=IFERROR(INDEX(COLLECT({EEO/HARRASSEMENT}, {NAME}, NAME@row, {EEO/HARRASSEMENT}, <>""), 1), "what gets output in the event of an error")

SEBERCAW · 08/08/22

Thanks so much

Paul Newcome · 08/08/22

Happy to help. 👍️

Best Answer