Thread: Substituting cell content into a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
  
Posts: 811
Default Substituting cell content into a formula
"John" wrote in message
...
More simply put, I have a hard coded formula =Jan!A4 in my report that I'd
like to change the worksheet and row specification to say =Feb!A22 based
on
the contents of a cell containing the text "Feb" and another cell
containing
"22"?

Hi John,

If "Feb" is in cell A1 and "22" is in cell A2, the following formula
will do what you're looking for:

=INDIRECT(A1 & "!A" & A2)

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm


Reply With QuoteReply With Quote