| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Check for errors
{=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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| Auto spell check as in word | Excel Discussion (Misc queries) | |||
| check box formatting | Excel Discussion (Misc queries) | |||
| Using a Check Box as a control item | Excel Discussion (Misc queries) | |||
| Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Threaded Mode
