How to create an Index Match Formula for multiple sheets?


I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information.

The destination sheet has two columns that it will look at.

  1. A "TIDC" column where staff members place a ticket code
  2. An "Assigned to" column, which is a contact list column

If I were just looking at one sheet the formula would look something like:

=INDEX({Sheet1 Assigned To},MATCH(TIDC@row,{Sheet1 TIDC},0))

I have tried to stack IFERRORs as well as nest IF formulas but it does not seem to function properly.

Any help would be very much appreciated.

Thank you,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!