Thread: How do I use cell contents as an address in a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default How do I use cell contents as an address in a formula
=INDIRECT("'"&G2&"'!B38")


--
Regards,
Dave


"tomeck" wrote:

I want to create a formula like follows:
= 'sheet name'!B38 where 'sheet name' is the contents of another cell,
such as g2.

So, if g2 contained "Division 1" as its contents, the formula would return
the contents of the cell B38 on thesheet labeled "Division 1"
Reply With QuoteReply With Quote