Pass Cell Address to OFFSET

[Guest]

Hello. I have calculated a cell address of say $A$1 using the CELL function.
I would now like to use the OFFSET function to get the value of what's in say
cell B1. How do I pass this text cell address to a usable input into the
OFFSET function. Thank you very much for your input.

 

[T. Valko]

Use INDIRECT.

Either wrap the CELL formula inside INDIRECT or put the CELL formula in
another cell and use INDIRECT to reference that cell.

 

[Guest]

Excellent - Thanks much. I used this and it worked perfectly!

 

[T. Valko]

You're welcome. Thanks for the feedback!