"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?