{=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