Forum Discussion
Alternative to offset indirect for worksheet references
Hi, I can't seem to find something in the help which matches what I'm looking for. I have a workbook with a worksheet of input parameters, one of which I want to use to select a worksheet with a...
Hi Simon
You could try INDEX (see attached) with a formula like this
=INDEX( INDIRECT($A$3&"!$A$1:$AV$365"), ROW(A1), COLUMN(A1) )
Hi Wyn,
Thanks, wouldn't that still be slow to calculate on large spreadsheet with data tables because of the use of Indirect, Rows and Columns which I understand are volatiles?
Thanks,
Simon
- Hi Simon,
I would think it would be quicker. I don't believe ROW and COLUMN are volatile plus using INDEX instead of OFFSET should speed things up
Do the different Matrices have to be on different sheets?
Is consolidating them into a single data set using Power Query an option?
