IFERROR with Index / Match from 3 sheets.

Saj

Hi All,

Trying to search value from 3 sheets and using IFERROR with Index / Match and am getting Incorrect Argument error.

=IFERROR(IFERROR(IFERROR(INDEX({Project Intake Project Name}, MATCH([Project ID]@row, {Project Intake Project ID}, 0))), INDEX({Completed Project Name}, MATCH([Project ID]@row, {Completed Project ID}, 0))), INDEX({Inactivated project Name}, MATCH([Project ID]@row, {Inactivated Project ID}, 0))

Thanks in advance,

Carson Penticuff

You need one more closing parenthesis at the end.

Edit:

After looking a little closer, I believe there are a few structural issues. Give this one a try:

=IFERROR(IFERROR(INDEX({Project Intake Project Name}, MATCH([Project ID]@row, {Project Intake Project ID}, 0)), INDEX({Completed Project Name}, MATCH([Project ID]@row, {Completed Project ID}, 0))), INDEX({Inactivated project Name}, MATCH([Project ID]@row, {Inactivated Project ID}, 0)))