Thread: Idexing Question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dq dq is offline
external usenet poster
  
Posts: 46
Default Idexing Question
Change the formula to
=INDIRECT("'" &A7&"'!A1")
Make sure to have all the double and single quotes as mentioned

DQ

Reply With QuoteReply With Quote