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