Hi all,
I have a problem - I am using Index Match Match (calling a 2x2 matrix) inside an existing sheet in excel.
I want to see if there is a way to use Index Match Match with the ability to call different sheets. Currently I have to use Indirect, which is horrible, since you can't really add rows and columns (since Indirect needs a specific cell name, which does not move dynamically when you add rows, while Index Match does).
Some more colour on the problem:
* I have 3 sheets with historical information about 3 different companies
* all the data is located at the exact same location in all the different sheets (for example, you can find the Sales for 2018 for all the companies, in their respective sheets, in cell AB13)
* I have a model, which used historical information for a company and does projections for 5 years
* If I want to switch between the companies, I either need to re-link the cells to the different companies each time, or use Indirect - which is bad, since you can't add rows and columns
I hope I am clear. Would appreciate help on this.
Thanks
Bookmarks