Forum Discussion
Match Index Multiple Worksheets
Hi. 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)....
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.
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.