Forum Discussion
Indirect relative to the referenced cell
Immortalis It is a volatile function so it might slow down your worksheet if you have 10,000 of these, but how about =INDIRECT(OFFSET(A1,3,4,1,1)) in cell A1?
The Offset function is moving from the current cell (A1), down 3 rows, over 4 columns, and choosing a range that is one row by one column tall. If E4 contains the test J1, then this formula will return the value from J1.
Immortalis It is a volatile function so it might slow down your worksheet if you have 10,000 of these, but how about =INDIRECT(OFFSET(A1,3,4,1,1)) in cell A1?
The Offset function is moving from the current cell (A1), down 3 rows, over 4 columns, and choosing a range that is one row by one column tall. If E4 contains the test J1, then this formula will return the value from J1.
Bill Jelen Thank you for your response. Yes, because of it's volatility I didn't want to use the OFFSET function but since there have been no solutions, it seems I have no choice.
It's a little disappointing but after the time I spent trying to solve it with no luck, I'm actually not surprised it can't be done the way I'd like.
No worries. Thank you very much! 🙂