View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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