Vlookup problem

[jerryjaysr]

Every month I will need to change the path for the lookup

see code

=IF(ISERROR(VLOOKUP(B9,[vlookup.xls]Sheet1!$A$2:$K$22,5,B9)),"",VLOOKUP(B9,[vlookup.xls]Sheet1!$A$2:$K$22,5,B9))

The vlookup.xls page will change every month. I have tried to type in a certain cell that would select the right path.

I was hoping to do this:

=IF(ISERROR(VLOOKUP(B9,["Sheet1valueD20]Sheet1!$A$2:$K$22,5,B9)),"",VLOOKUP(B9,["sheet1valueD20!}$A$2:$K$22,5,B9))

where I would enter the path in the cell D2 on sheet1. The data will be in another workbook. Is this too confusing???
I actually have 2 different books that are over 10 meg each and wanting to import all this data into another book periodically to do graphing, so I am using the vlookup. Just learned it....cool stuff.

[NBVC]

Try:

=IF(ISNA(VLOOKUP(B9,INDIRECT("'["&D20&"]Sheet1'!$A$2:$K$22"),5,B9)),"",VLOOKUP(B9,INDIRECT("'["&D20&"]Sheet1'!$A$2:$K$22"),5,B9))

[jerryjaysr]

works great!

Thanks.....