If formula?

  • Thread starter Thread starter Ginger
  • Start date Start date
G

Ginger

Hello everyone,

I am having a difficult time coming up with a formula that
will return a yes or no.

I am trying to see if the value in cell b2 matches with
any value in range c2:c1000, if there is a match I would
the formula to return a yes.

Can anyone please help me?

Thank you!!!
 
Hi
one way:
=IF(COUNTIF(C2:C1000,B2)>0,"Yes","No")

another way
=IF(OR(C2:C1000=B2),"Yes","No")
 
Thank You!!!
-----Original Message-----
Hi
one way:
=IF(COUNTIF(C2:C1000,B2)>0,"Yes","No")

another way
=IF(OR(C2:C1000=B2),"Yes","No")


--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
Sorry I forgot to add if there is no value in B2 I would
like the formula to return null ""

How would I add this in the following formual that you
have supplied: =IF(OR(C2:C1000=B2),"Yes","No")

Thank you again
 
Frank,
=IF(B2="","",IF(OR(C2:C1000=B2),"Yes","No"))
Click to expand...

I can only get this formula to work when entered as an array formula, is
that right or am I missing something?

Regards

Sandy
 
Back
Top