When is MATCH not a MATCH = #N/A

[Spellbound]

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

[NBVC]

Try:

Please Login or Register  to view this content.

confirmed with CSE keys.

[Spellbound]

That's great, it seems to have cured the problem.

I had tried ISNUMBER but obviously not in the correct way.

Now I just have to spend the next few hours amending my workbook to take into account the new features.

Thanks again...

[NBVC]

You're welcome !