Thank you for helping out.
I have modified the formula to:

{=IF(J665="","",INDEX(CC!$Q$31:$T$990,MATCH(OrdAck !M665,CC!$C$31:$C$990,0),M
ATCH(OrdAck!J665,CC!$Q$30:$T$30,1)))}

Unless I have misunderstood your fix, the formula still returns #N/A


"Peo Sjoblom" wrote in message
...
IF(J667="","",your_formula))


Regards,

Peo Sjoblom

"Pat" wrote:

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