Hi Pat

then this should work for you
=IF(AND('P05'!A32=2,'P05'!V32<"",COUNTIF('CC04'!C 77:C100,P05!BC32)=1),"update","")

Cheers
julieD

"Pat" wrote in message
...
Hello JulieD,

- what do you mean by "and BC matches sheet CC04 C77:C1000"
Sorry this should have been BC32 which if it find a match in sheet
CC04!C77:C1000
- as excel treats dates as numbers it is difficult to test for whether or
not V32 contains "any" date, so is there a range of valid dates that we
could test for instead.
I would be happy to test if there is a value in V32 of whatever format.

Regards
Pat


"JulieD" wrote in message
...
Hi Pat

couple of questions ...
- what do you mean by "and BC matches sheet CC04 C77:C1000"
- as excel treats dates as numbers it is difficult to test for whether or
not V32 contains "any" date, so is there a range of valid dates that we
could test for instead.

Cheers
JulieD


"Pat" wrote in message
...
In sheet P05 if A32 contains the value 2 and V32 contains a date and BC
matches sheet CC04 C77:C1000, return "Update"

Anyone know the formula for this?

Thanks if you can be of help.
Pat