How to use a cell value as part of a workbook reference, in a formula?

Hi,

It is probably a very simple solution to this problem. Have tried to search for it, but haven't found any, and is hoping that someone is able to help with the problem

I have this formula:
=IF(A2&B2="";;SUMPRODUCT(1*('G:\Shared\3_HMS and Kvalitet (QC)\3.5_DM\[Dokumentkontroll.xlsm]Registration'!CI:CI=A2&B2))+SUMPRODUCT(1*('G:\Shared\3_HMS and Kvalitet (QC)\3.5_DM\[Dokumentkontroll.xlsm]Returned documents'!P:P=A2&B2)))

What i want to do is to change the first part of the workbook reference, this part:
G:\Shared\3_HMS and Kvalitet (QC)\3.5_DM\

With text that is stored in a cell, say L2. This way i will be able to make the workbook reference dynamic, so i don't have to repair broken links, when someone desides to change a folder name.

Any help will be appreciated

Why don't you check out your earlier thread, where there is an answer for you, rather than posting again?

Pete