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([email protected],{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