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


"mjones" wrote in message
...
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