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)