Thread: How to replace sheet name in a formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JS JS is offline
external usenet poster
  
Posts: 44
Default How to replace sheet name in a formula?
Hi,
How to replace sheet name in a formula?
Say, I have 3 sheets named Sheet A, Sheet B, and Sheet C.
D5 contents a formula VLOOKUP(A5,'Sheet A'!$B$7:$F$36,2,FALSE). If I type
"Sheet B" in A1, "Sheet A" in the formula is replaced automatically by A1
content.

thanks
js

Reply With QuoteReply With Quote