| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add checking
{=IF(ISERROR(INDEX(P05!$AO$4:$AO$1000,MATCH(CC!$C7 7,P05!$BL$24:$BL$1000,0))),"",INDEX(P05!$AO$4:$AO$ 1000,MATCH(CC!$C77,P05!$BL$4:$BL$1000,0)))}
Once the above formula matches I want then to check if the corresponding cell in P05!Y$24:Y$1000 contains a value. The value must be in the correct cell to give a true result. Can anyone help me with this? Thanks Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking a net drive | Excel Discussion (Misc queries) | |||
| Why does spelling check close Excel when checking spanish? | Excel Discussion (Misc queries) | |||
| error checking reports a value in the formula is of the wrong dat. | Excel Worksheet Functions | |||
Threaded Mode
