Bring results from multiple arrays using Index Match

[Spiru]

Hello,

Is there a way to bring results from various arrays (sheets) using index match? I can search for the result in one table, but other information with other matching criteria are in other sheets and I don't know how to change the formula so that it searches multiple sheets.

Any suggestions, please?

 

[SanjayGMusafir]

Hello,

Is there a way to bring results from various arrays (sheets) using index match? I can search for the result in one table, but other information with other matching criteria are in other sheets and I don't know how to change the formula so that it searches multiple sheets.

Any suggestions, please?

Share some sample data using XL2BB and alos update current version of Excel you are using right now. Also update the same in your profile so that it's visible to everyone who visits this thread to help you out.

The solution would depend upon the above two factors - Kind of data you want to fetch and Excel version