Match Index Multiple Worksheets

Occasional Contributor



I need to INDEX MATCH across multiple sheets. I have an amalgamated set of coordinates in one cell. This will match amalgamated coordinates in other cells across multiple sheets (6 in total). Once the match is completed I need to return a value that corresponds to that match. 


So, if a1 matches 'sheet1'a1 index b1. Any help is appreciated and happy to give further information.





1 Reply
The limitation with INDEX-MATCH are the functions do not support 3D referencing. The less commonly used 'reference' arrangement of INDEX does support multiple areas but those areas cannot be across multiple sheets.

Depending on the version of Excel you're using and the arrangement of the data, there may be a workaround if you're able to upload a sample.