Hey

I am having trouble with a project. I am using VLOOKUP to retrieve a price of a product from another workbook
This is the formula i am using =IF(B10="";"";VLOOKUP(B10;'Q:\Veitingastaður\JónIngi\Hráefnislisti (MASTERSKJAL).xlsm'!Hráefnalisti[[#All];[Nafn]:[verð]];2;FALSE)

There is a workbook(Hráefnislisti (MASTERSKJAL).xlsm) containing all the information and will be used by many other workbooks.

I have linked them together but I need to open the other workbook every time I need to update the values.
As both of them will be password protected will that effect this process?


Here is a sample of what I am trying to do
Master file.xlsm
Worbook.xlsm



Thanks,
Jón Ingi