Hi

Ived scanned this site and still hav'nt found a solution to my problem. It
seems like it is impossible.

Here it goes:

I have several user workbooks (calculations) with lookup formulas, that
lookup prices in a specific version of the pricelist. The cells that include
these lookups are locked and sheet protected.

Now my problem is that I would like to, by one simple input, to define which
pricelist the lookups should be made in without unlocking, find and rename.

The formula i need is something like this:

=VLOOKUP(A$3,"'c:\myfolder\pricelists\[ver"&$A$1"&".xls]Sheet1'!$A$1:$B$999,2,FALSE)

where the version of the pricelist is inputed in A1

Clearly this does'nt work, but i think it describes what I need.

The indirect function needs the priceliste too be open and I'vd tried the
pull function by Harlan Grove found otherwhere here, and it works fine in
other situations, but in this case it slows down unacceptable.

Does anyone have a workaround to this problem?

Michael