Is it possible to use a cell adress that is typed in a cell?

J

Jon S

For example if I would type, say, "A1" into a cell, for example B1, could I
then somehow extract the value A1 from B1 and use that information to point a
function at A1?
 
S

Sloth

I think you want the INDIRECT function.

Example:
A1: 21
B1: ="A"&ROW()
C1: =INDIRECT(B1)

B1 will output the text string "A1"
C1 will output 21.
 
Top