Thread: Cell reference with variable column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mjones mjones is offline
external usenet poster
  
Posts: 86
Default Cell reference with variable column
On Apr 24, 3:36 pm, Mike H wrote:
Hi,

=INDIRECT(F1 & 6)

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

Mike

"mjones" wrote:
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

Thanks everyone!
Reply With QuoteReply With Quote