Thread: Using a Wildcard (*) in formula accessing sheets in workbook.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pwk pwk is offline
external usenet poster
  
Posts: 9
Default Using a Wildcard (*) in formula accessing sheets in workbook.
I have this formula accessing a sheet named 142007 , 1
(142007=1-4-2007)

=VLOOKUP(A2,'142007, 1'!$C$3:$P$746,3,FALSE)

How can I access the next day using a wildcard or another option.
I've tried the following and Excel crashes and shuts down.

=VLOOKUP(A2,'*2007, 1'!$C$3:$P$746,3,FALSE)

Any help would be appreciated.

Reply With QuoteReply With Quote