Forum Discussion

Alfieb1996's avatar
Alfieb1996
Brass Contributor
Jun 14, 2022

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). 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.

 

Thanks,

 

Alfie

excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Jun 14, 2022
    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.

Resources