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.
(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.