INDEX & MATCH function showing "#INCORRECT ARGUMENT SET"

syam2k

When trying to run this it shows "#INCORRECT ARGUMENT SET" error, not sure where i went wrong.

=IFERROR(INDEX({East - Service Status}, MATCH([Ticket No]@row, {East - Service Range 1}, 0)), IFERROR(INDEX({South - Service Status}, MATCH([Ticket No]@row, {South - Service Range 1}, 0)), IFERROR(INDEX({Tamil Nadu - Status}, MATCH([Ticket No]@row, {Tamil Nadu - Service Range 1}, 0)), IFERROR(INDEX({Puducherry - Service Range 1}, MATCH([Ticket No]@row, {Puducherry - Service Range 2}, 0)), IFERROR(INDEX({Rajasthan - Service Range 1}, MATCH([Ticket No]@row, {Rajasthan - Service Range 2}, 0)), IFERROR(INDEX({Andhra Pradesh - Service Range 1}, MATCH([Ticket No]@row, {Andhra Pradesh - Service Range 2}, 0)), IFERROR(INDEX({Delhi - Service Range 1}, MATCH([Ticket No]@row, {Delhi - Service Range 2}, 0)), IFERROR(INDEX({Karnataka - Service Range 1}, MATCH([Ticket No]@row, {Karnataka - Service Range 2}, 0)), 0))))))))

Any suggestion would be greatly appreciated.

1. Service Range mentioned is reference to another sheet

Michelle Choate 2

Yo What are you trying to do with this formula? Can you provide more description? Also, here is a great question that has already been answered in the community that might help:

Index Match Across Multiple Sheets

Nancy Heater

Nov 29, 2022

Hello Smartsheet Community!

I have reviewed a few similar posts on this subject, but have further questions ...

Examples shown on other discussion threads, show to use stacked IFERRORs, and repeated Index/Match in the formula to look at multiple sheets, however I am not able to get this to work.

When you're stacking IFERROR's, do the number of IFERRORS need to equal the number of sheets the formula is referencing?

I am trying to do an Index/Match with 5 different sheets, and the number of sheets will grow year after year.

Example below with formula "broken out" to be easier to read.

=IFERROR(IFERROR(IFERROR(IFERROR(IFERROR

(INDEX({Sheet1 Range 1},MATCH(Synth@row,{Sheet1 Range 2},0)),

INDEX({Sheet2 Range 1},MATCH(Synth@row,{Sheet2 Range2},0))),

INDEX({Sheet3 Range 1},MATCH(Synth@row,{Sheet3 Range 2},0))),

INDEX({Sheet4 Range 1},MATCH(Synth@row,{Sheet4 Range 2},0))),

INDEX({Sheet5 Range 1},MATCH(Synth@row,{Sheet5 Range 2},0)))

Thank you in advance for the assistance!

---

View Post