Return result from multiple criteria
 

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

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

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

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

Hi Pat

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

Cheers
julieD

"Pat" wrote in message
...
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

Hi Frank

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

Cheers
julieD

"Frank Kabel" wrote in message
...
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

Hi Julie
wanted to write
ISNUMBER
Thanks for the correction

--
Regards
Frank Kabel
Frankfurt, Germany
"JulieD" schrieb im Newsbeitrag
...
Hi Frank

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

Cheers
julieD

"Frank Kabel" wrote in message
...
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