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))))
