Hi Beto
if your other workbook is OPEN you may try the following
=VLOOKUP(B10,INDIRECT("'[" & A1 & "]Products'!$A$2:$B$10"),2,0)
This won't work if the other workbook is closed.


You may also have a look at the following thread (describing further
alternatives for accessing closed workbooks): http://tinyurl.com/2c62u

--
Regards
Frank Kabel
Frankfurt, Germany

Beto wrote:
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,