Index/Match Formula Across 2+ Sheets

aecross

Hi - I ultimately need to index a column from 5 sheets. They are named the same and have the same settings. I could figure out the formula for 2 sheets, but struggling with adding more than that.

Here is what i have to capture at least 3 sheets, I'm getting the #INCORRECT ARGUMENT SET error.

=IFERROR(INDEX({SC - MASTER TRACKING SHEET Range 1}, MATCH(CPN@row, {SC - MASTER TRACKING SHEET Range 2}, 0)), IFERROR(INDEX({WM - MASTER TRACKING SHEET Range 1}, MATCH(CPN@row, {WM - MASTER TRACKING SHEET Range 2}, 0))), IFERROR(INDEX({SE - MASTER TRACKING S Range 1}, MATCH(CPN@row, {SE - MASTER TRACKING S Range 2}, 0))))

KPH

Hi @aecross

Your approach looks good but I think one of the closing parentheses is in the wrong place. Can you try taking the one in bold and moving it to the end:

=IFERROR(INDEX({SC - MASTER TRACKING SHEET Range 1}, MATCH(CPN@row, {SC - MASTER TRACKING SHEET Range 2}, 0)), IFERROR(INDEX({WM - MASTER TRACKING SHEET Range 1}, MATCH(CPN@row, {WM - MASTER TRACKING SHEET Range 2}, 0))), IFERROR(INDEX({SE - MASTER TRACKING S Range 1}, MATCH(CPN@row, {SE - MASTER TRACKING S Range 2}, 0))))

Like this

=IFERROR(INDEX({SC - MASTER TRACKING SHEET Range 1}, MATCH(CPN@row, {SC - MASTER TRACKING SHEET Range 2}, 0)), IFERROR(INDEX({WM - MASTER TRACKING SHEET Range 1}, MATCH(CPN@row, {WM - MASTER TRACKING SHEET Range 2}, 0)), IFERROR(INDEX({SE - MASTER TRACKING S Range 1}, MATCH(CPN@row, {SE - MASTER TRACKING S Range 2}, 0)))))