Ron,

Your first reply works perfectly.
You probably didn't NAME G5 "Zip5"
Actually, I did name G5 "Zip5", I forgot to name D2:D60 "Zone" :-(
Sorry about that. Anyway, I tried it again and it works great!

Thanks again,
Jeff

"Ron Rosenfeld" wrote:

On Tue, 12 Jan 2010 07:28:01 -0800, Jeff Jensen
wrote:

Hi Ron,

I named B2:B60 "StartZip" and C2:C60 "EndZip"
Then I entered your formula in H5 and entered a zip code (52103) in G5
I get a #NAME? error.

What am I doing wrong?

You probably didn't NAME G5 "Zip5"


To answer your question: If I enter a zip code that's not equal to or
between B & C
(for example:
B2 = 50001, C2 = 50499
B3 = 50501, C3 = 50599
50500 is not equal to or between any of the above)
I want it to display some kind of error.


The formula I gave will return a zero (0) if there is no match, so you could
use an IF statement to check for that and display whatever error message you
wish:

=IF(myFormula=0,"Error Message", myFormula)

--ron
.