Earlier I posted for help to fix an error message. I will try to explain the
problem better with the hope of someone being able to help.

J667 contains a formula and if there is nothing returned by the formula the
cell remains blank.
If J667 is blank the formula below in K667 will return #N/A

{=IF(ISNUMBER(J667),INDEX(CC!$Q$31:$T$990,MATCH(Or dAck!M667,CC!$C$31:$C$990,
0),MATCH(OrdAck!J667,CC!$Q$30:$T$30,1)),0)}

Using conditional formatting in K667 will not be suitable in this instance.
I need to be able to remove the error with error checking in the formula.

I would appreciate any assistance with this problem.
Regards
Pat