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

[Peo Sjoblom]

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

[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" <PeoSjoblom@discussions.microsoft.com> wrote in message
news:8C5A5F1C-B5B2-4FA3-AFBB-1CE0265C7752@microsoft.com...
> 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(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
> >
> >
> >

[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" <glass_patrick@hotmail.com> wrote in message
news:OUx45uYBFHA.4028@TK2MSFTNGP15.phx.gbl...
> 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" <PeoSjoblom@discussions.microsoft.com> wrote in message
> news:8C5A5F1C-B5B2-4FA3-AFBB-1CE0265C7752@microsoft.com...
>> 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(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
>> >
>> >
>> >
>
>

[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" <terre08@mvps.org> wrote in message
news:O%23OcXUaBFHA.2112@TK2MSFTNGP14.phx.gbl...
> 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" <glass_patrick@hotmail.com> wrote in message
> news:OUx45uYBFHA.4028@TK2MSFTNGP15.phx.gbl...
> > 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" <PeoSjoblom@discussions.microsoft.com> wrote in message
> > news:8C5A5F1C-B5B2-4FA3-AFBB-1CE0265C7752@microsoft.com...
> >> 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(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
> >> >
> >> >
> >> >
> >
> >
>
>