INDEX & MATCH function showing "#INCORRECT ARGUMENT SET"

syam2k
syam2k
edited 11/06/24 in Formulas and Functions

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!