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
|