OFFSET

J

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top