Vlookup with variable workbook name

[Mihael]

Hi,

I wan't to use the vlookup formula that needs to search with a variable workbookname. This variable workbookname is in cell N15 and what I have is this:

=VLOOKUP("Diameter_ 244.175";'J:\Kwaliteit Helmond\FINAL INSPECTION REPORTS\2018\0_WC_340_Duramax\DuraMax_144751\[N15.xls"]"N15'!$B$1:$K$10000;1;FALSE)

But it will not work..

What is going wrong in this formula??

 

[Legacy 143009]

=INDIRECT(N15&'!$B$1:$K$10000')

In fact I didn't understand your N15 path but it should be something like above. INDIRECT function converts cell values to range addresses.

 

[Mihael]

Sorry, the N15 cell contains the workbook name, for instance "book1"

 

[Mihael]

I don't understand where I have to put =INDIRECT formula in the VLOOKUP formula?