Hi
try
=IF(AND(A32="value 2",ISDATE(V32),COUNTIF(C77:C1000,BC1)),"Update","n ot
update")

"Pat" wrote:

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