Cell reference with variable column
=INDIRECT(C1&"1")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"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
|