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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using a Wildcard (*) in formula accessing sheets in workbook. (https://www.excelbanter.com/excel-worksheet-functions/129155-using-wildcard-%2A-formula-accessing-sheets-workbook.html)

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.

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

PWK wrote:
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.

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