Thanks OJ,

Worked a treat.

Cheers,
Nathan

"OJ" wrote in message oups.com...
Hi,
I forgot to mention that this will return "Q is NOT present" if the
vlookup produces an error....is that an issue? If so, try this...

=3DIF(ISERROR(VLOOKUP(G5,Calendar!$A:$G,=AD7)),"VL OOKUP
FAILED",IF(ISERROR(FIND("Q",VLOOKUP(G5,Calendar!$A :$G,=AD7))),"Q is NOT
present","Q=20
Is Present"))

Regards,
OJ