View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default VLOOKUP WITH INDIRECT

INDIRECT won't work on closed files.

The INDIRECT function *requires* that the referenced file(s) *MUST* be open.
This is usually not desireable.

A possible workaround is to download the *free* add-in, Morefunc.xll from
this site:


http://xcell05.free.fr/morefunc/english/index.htm


It has a function called INDIRECT.EXT that works the same as the built-in
INDIRECT *except* it will work on closed files.



--
Biff
Microsoft Excel MVP


"excelent" wrote in message
...
Hi experts:

Cant remember how to combine Vlooup with Indirect
This 1 works ok
=VLOOKUP(B3,'C:\Users\pm\Desktop\[Varelager_XAL.xls]Sheet1'!B2:R15000,2)

Then ill have a dynamic range insted of R15000 then use a number in cell
B5
this is what i got but it wont work
Can sombody pls. help :-)

=VLOOKUP(B3,INDIRECT("'C:\Users\pm\Desktop\[Varelager_XAL.xls]Sheet1'!B2:R"&B5),2)