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