I am trying to create a formula to do the following:

A1 contains a zip code.
Column B is a listing of zip codes with neach code in
it's own cell from B1 to B10.

I want what I think is an IF/Then formula that says IF A1
is found in the range from B1 to B10, then "Yes", if
not "No". Can anyone ehlp? Thanks.