Cell reference with variable column

M

mjones

Hi all,

Is there a function or way to say A1 where A is a variable that comes
from another cell to the other cell has just he column letter like B?

Thanks,

Michele
 
B

Bob Phillips

=INDIRECT(C1&"1")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

Peo Sjoblom

If you put B in A5 then this formula will return what's in B1, if you put C
in A5 it will be C1


=INDIRECT(A5&1)



--


Regards,


Peo Sjoblom
 
M

Mike H

Hi,

=INDIRECT(F1 & 6)

If F1 contained the letter C then this would return the value of C6

Mike
 
Top