Link update within formula Index Match function

[mamun_ges]

Hi,

I am using following formula in a cell to get data from another workbook. The formula is

{=INDEX('D:\Offical\Calculation.xls]Sheet 1'!$B$2:$B$598,SMALL(IF('D:\Offical\Calculation.xls]Sheet 1'!$D$2:$D$598=L$3,ROW('D:\Offical\Calculation.xls]Sheet 1'!$D$2:$D$598)-ROW(INDEX('D:\Offical\Calculation.xls]Sheet 1'!$D$2:$D$598,1,1))+1),M2))}

but whenever I am changing the formula file in another folder where there is another calculation file but there column is not same as formula which giving wrong data.

Can anyone help me in this formula that when ever I am changing the file it automatically update the location and get me the correct value.

If it is possible in VBA will be helpful. I will be Sorry if I am unable to explain.

Thanking You.
Mamun