Hi there, i've been having problem with this formula every time i changed a certain aspect;

The Current formula currently looks like this;

=IF($B3=0,0,INDEX('Dta Sht'!$D$1:$D$36000,MATCH(1,($B3='Dta Sht'!$A$1:$A$36000)*((VLOOKUP(C$1,$AC:$AD,2,))='Dta Sht'!$C$1:$C$36000),0)))

And all I wanted to do was a simply change in the vlookup part to this;

=IF($B3=0,0,INDEX('Dta Sht'!$D$1:$D$36000,MATCH(1,($B3='Dta Sht'!$A$1:$A$36000)*((VLOOKUP(C$1,Dta!$K$1:$L$67,2,))='Dta Sht'!$C$1:$C$36000),0)))

I do have to press ctrl, shift & enter to usually get this formula to work but it just won't accept the new vlookup values, any help would be appreciated!