Formula Help
 

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.

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

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?

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

.