{=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)}

The above formula does not check for errors which results in #N/A being
returned on some cells where the formula is used. I have changed it to:

{=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)INDEX(CC!$Q$31:$T$990,MATCH(OrdA ck!M667,CC!$C$31:$C$990,0),MATCH(OrdAck!J667,CC!$Q $30:$T$30,1)),0)}

this is obviously not correct, can someone help!

Thanks
Pat