Return a true false if a particular numbers appear in particular cells

**khank** · 02-11-2012, 02:36 PM

In Cell A1=8, in Cell B1=3, in Cell C1=2

I'm looking for a return of True/False or Yes/No if any of the above cells contain a 3,4,5,7 in Cell E1.

**jeffreybrown** · 02-11-2012, 02:46 PM

How about...

=IF(SUMPRODUCT(--ISNUMBER(MATCH(A1:C1,{3,4,5,7},0))),"Yes","No")

**khank** · 02-11-2012, 03:06 PM

Thank you! Have a great weekend.

**jeffreybrown** · 02-11-2012, 03:07 PM

You're very welcome and glad it worked out for you

Hope you also have a blessed weekend.

Re: Return a true false if a particular numbers appear in particular cells