|
Help with error message - please!
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 |
| All times are GMT +1. The time now is 04:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com