Forum Discussion
Index Match Erray - concatenating cells to create an array
Hello, I was triyng to set an Index-Match formula which could automatically change reference sheet into a workbook based on an input (basically the sheet name). More specifically, I have 46 sheet...
Check out the INDIRECT function in Help. Note however that that function is a sign of poor spreadsheet design. Your calculations become far simpler and more efficient if you put the data currently on 46 sheets into a single worksheet, with the 1-46 as values in an additional column.