"IF" with range in Excel

[b_madoff]

Is it possible to to write a formula that references another cell and compares it with a range of other cells to produce an either/or result?

In other words, if I am looking at a name in a cell, and I want to know whether or not that name is also found within a range of other cells containing various names, how would I write the formula?

While not a serious example of an Excel formula, I'm thinking of something that would duplicate the intent of the following faux formula (with apologies to SQL):

=IF(A2(in(B2:B14)),"yes",no")

Basically, is there a way to produce the effect of the imaginary "in" function in the faux formula above?

[MarvinP]

Hi b_madoff and welcome to the forum,

The thread of http://www.excelforum.com/excel-prog...g-a-value.html is very similar to your question and might solve it.

Read it and then supply a sample of what you have if the above doesn't help.

[b_madoff]

Hi b_madoff and welcome to the forum,

The thread of http://www.excelforum.com/excel-prog...g-a-value.html is very similar to your question and might solve it.

Read it and then supply a sample of what you have if the above doesn't help.

Thanks, that did it. My version looks like =IF(COUNTIF($F$4:$F$9,H4)>0,"yes","no")

[scottylad2]

=IF(OR(A1=B1:B16),"yes","no") not sure of the SQL equivalent query though