I wonder if someone can help me. I've been stuck on this for a while. I have identical multiple sheets in the same book. I am creating a sheet where I can pull data from the various sheets depending on the value in a certain cell which will reference the sheet title I want to get the data from. When the sheet has been identified I then want it to match certain criteria to get to a certain value. I've been trying to use indirect, index, multiple match but can't seem to do it. Here is my code.... =INDEX(INDIRECT("'"&B11&"'!$N$39:$AY$62"),MATCH(1,(INDIRECT(D11,"B11"!$E$N$39:$N$62)*(INDIRECT(B11&"'!$O$39:$O$62"=E11)*(INDIRECT("'"&B11&"'!$Q$39:$Q$62"=H11),0)))),26)
B11 is the cell in my main sheet that will change depending what sheet I need to get the values from. I then need to match certain criteria ( d11, e11, h11,) with ranges in that specified sheet.
B11 is the cell in my main sheet that will change depending what sheet I need to get the values from. I then need to match certain criteria ( d11, e11, h11,) with ranges in that specified sheet.