OFFSET

[Jose Mourinho]

I have A1 cell returning the value in A2, using '=A2'

In B1, is it possible to return the value in a fixed location relative to
'=A2' (say, +3 columnds to D2) using OFFSET, or other function?

e.g. If I changed A1 from '=A2' to '=A5', I want B1 to now return value in D5.

Many thanks

 

[David Biddulph]

No, but if in A1 you were to put the text string A5, rather than the formula
=A5, then one cell could pick up the contents of A5, using the INDIRECT
function =INDIRECT(A1), and another cell could pick up D5 using a
combination of OFFSET and INDIRECT.