One way is to put a formula in a cell referencing the month and then
INDIRECT in your VLookup formula.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bishop" wrote in message
...
Here is my vlookup formula:

=VLOOKUP($A6,'[Feb 09 $7
Report.xls]By_Rep_by_Filter'!$F$1:$P$5000,8,FALSE)

Which works. However, the spreadsheet "Feb 09 $7 Report" changes every
month. So next month it will be "Mar 09 $7 Report". I want to use a wild
card in the table_array so that no matter which months report I have open
it
will know to look at the $7 Report. I tried this:

=VLOOKUP($A6,'[????? $7 Report.xls]By_Rep_by_Filter'!$F$1:$P$5000,8,FALSE)

and this:

=VLOOKUP($A6,'[* $7 Report.xls]By_Rep_by_Filter'!$F$1:$P$5000,8,FALSE)

but neither of those works. How do I accomplish this?