Return result from multiple criteria

[Pat]

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

 

[JulieD]

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]

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

 

[Guest]

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

 

[JulieD]

Hi Pat

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

Cheers
julieD

 

[JulieD]

Hi Frank

i thought the ISDATE() can only be used in VBA?

Cheers
julieD

 

[Frank Kabel]

Hi Julie
wanted to write
ISNUMBER
Thanks for the correction