Hi everyone,
I tried searching the internet for this one but no luck. I'm trying to use the index-match-match function while calling another sheet. For simplicity here's an example: =INDEX('Q215'!A3:A4,1,1).
So in this case, the sheet being called is "Q215." However, I need to call many different sheets with a different name for each quarter. Instead of changing the sheet name manually I would like to point it to a cell, but everything I have tried has ended as an error. What I would like is for the formula to end up looking like/or working in such a way as: =INDEX('(selected cell calls sheet Q215)'!A3:A4,1,1).
Any help would be much appreciated. Thanks!
Hugh
Bookmarks