Thread: OFFSET and INDIRECT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AirgasRob AirgasRob is offline
external usenet poster
  
Posts: 21
Default OFFSET and INDIRECT
Is it possible to use INDIRECT in a OFFSET formula?

Here is the formula =OFFSET(Sheet1!$B$29,,ROWS($1:1)-1)

I would like to replace $B$29 with =INDIRECT($F$1)
Reply With QuoteReply With Quote