Cell reference with variable column

[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

 

[Bob Phillips]

=INDIRECT(C1&"1")

--
HTH

Bob

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

 

[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

 

[Mike H]

Hi,

=INDIRECT(F1 & 6)

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

Mike

 

[mjones]

Hi,

=INDIRECT(F1 & 6)

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

Mike

Thanks everyone!