Hi,
I'm creating a template to search in a price list in a closed book, this
book will change its name every week, so I want to put the name of the
book in a cell and use this name as an argument in a vlookup function.
Is this feasible?

Ex:
A1 - PriceList0.xls

C10 - =VLOOKUP(B10,'P:\PRICES\[PriceList0.xls]Products'!$A$2:$B$10,2,0)

Now in C10 I'd like to change the formula to use the value in A1.

Any suggestions?

Regards,
--
Beto