Using a Wildcard (*) in formula accessing sheets in workbook.

  • Thread starter Thread starter PWK
  • Start date Start date
P

PWK

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.
 
PWK said:
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.
Click to expand...
One option would be to put the future dates in a hidden column and
access them with the indirect function

B
142007
152007
162007

=INDIRECT(B2&"!A1")
would return the value from cell A1 from a sheet named 152007 in a workbook
 
Back
Top