getting the contents of a cell using the cell address?

  • Thread starter Thread starter PBAR
  • Start date Start date
P

PBAR

Greetings,
I'm trying to create a formula to retrieve the contents of a cell. The
cell whose contents I want is dynamic and I get the cell address using MATCH
and ADDRESS. However, is there a way to retrieve the contents from a cell
by using its address besides manually typing the cell address in a CELL
function (as in =CELL("contents", worksheet1!EK37))? Is there way to nest
another formula in a CELL function? I tried =CELL("contents",
(CELL("contents", A1 [cell with the cell address I want to use])) but that
didn't work. Any ideas?

Thanks in advance!

Daemon
 
Hi

Some examples below:

=INDIRECT("C3)
or
A1="C3"
=INDIRECT(A1)
or
A1=3
=INDIRECT("A" & A1)
or
A1="C2:C100"
=SUM(INDIRECT(A1))

NB! The INDIRECT function always returns a range from range string. And when
used on range in another workbook, this workbook has to be opened -
otherwise an error is returned.
 
Back
Top