Hi everyone

Looking for some help again with the following formula, which has worked successfully in the past, although I believe it slows up my workbook quite considerably.

{=INDEX(Adjustments!$D$2:$D$2,MATCH(1,($DB3=Adjustments!$A$2:$A$2)*($B523=Adjustments!$B$2:$B$2)*($E523=Adjustments!$C$2:$C$2),0))}

In this instance, I am trying to use it with a much smaller list of data and I would like the formula to return a value when the MATCH is true but a 0 or 0.00 when the match is not found.

I have tried out a couple of possible solutions from my searches but none of them have resolved the problem. I still get the #N/A error when the MATCH is not found.

Hope someone has the answer