IF, 2 cells multiple criteria for both cells

[kvmike]

Hi,

New here, so apologies if my explanation is not great:
I am trying to get the following results
IF A1 = "black" or "white"
AND
IF B1 - "yellow" or "red" or "blue"
results:
TRUE= yes
FALSE = blank

Cells A1 and B1 can have numerous varying text in there, but i want a result if they both contain the corresponding text above at the same time.

Thanks in advance!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(AND(OR(A1={"Black","White"}),OR(B1={"Yellow","red","blue"})),"Yes","")

 

[kvmike]

Hi & welcome to MrExcel.
How about

=IF(AND(OR(A1={"Black","White"}),OR(B1={"Yellow","red","blue"})),"Yes","")

Absolutely amazing! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.