Thread: Using a cells contents to reference a sheet.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default Using a cells contents to reference a sheet.
Yes, you can do this by using the INDIRECT( ) function - you can build
up the sheet and the range within INDIRECT, something like;

=VLOOKUP(A5,INDIRECT(A1&"!$A:$F"),5,TRUE)

Pete

Reply With QuoteReply With Quote