| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| worksheet to worksheet . . . | Excel Worksheet Functions | |||
| Relative vs Absolute referencing of Workbooks | Charts and Charting in Excel | |||
| delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
| Number of Sheets in a workbook formula | Excel Worksheet Functions | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Linear Mode
