Formula Help

[Jerry]

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.

 

[Biff]

Hi!

Here's one way:

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

Biff

 

[Jerry]

Thanks Biff. It works with one annoying problem. If I
sort by column, A1 in the COUNTIF section ticks up one to
A2. I want it to remain on A1. Any ideas?