Hi!

Here's one way:

=IF(A1="","",IF(COUNTIF(B1:B10,A1)0,"Yes","No"))

Biff

-----Original Message-----
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.
.