Help with error message - please!

[Pat]

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(OrdAck!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

 

[Guest]

IF(J667="","",your_formula))


Regards,

Peo Sjoblom

 

[Pat]

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]

OK, assuming you by J667 meant OrdAck!J667 since you used ISNUMBER(J667) I
thought the blank was in that isnumber test cell, try

=IF(OrdAck!J667="","",your formula))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Pat]

The problem formula is in OrdAck! already, in cell K667. Perhaps the
formula in OrdAck!J667 should be changed first so that a value of at least
zero should be returned.
The formula in J667 is =PList!R623
PList!R623 will only have a numeric value if the user enters it.

Pat