Pass Cell Address to OFFSET

E

ExcelGuy555

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

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.
 

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

Similar Threads

Mapping integers to strings 6
Event recognition. 11
relative offset to a named cell 3
Excel does not accept text format! 0
Nested if statements creating a blank cell 1
Merging from an Excel file with graphics 1
OFFSET 1
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top