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

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

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

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" wrote in message
...
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

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

"Peo Sjoblom" wrote in message
...
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" wrote in message
...
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