Hi all.

I work for a college and we've divided up the country, by zip code, into
many many many different regions.

What I have is a worksheet in excel that looks like this

'MinZip' 'MaxZip' Region
75000 75899 DALLAS
76000 76899 DALLAS

Where MINZIP s the beginning number of a ZIPCode range for a particular
region, and MAX is the terminating zip code.

On a separate form, I have the listing of our applicants and their zip
codes. I was to create a lookup formula that says (in english):
If REALZIP is between MINZIP and MAXZIP on row one, return the region value
for row one.

If I had a straight list of zips in ascending order, it'd be easy with
VLOOKUP:
=VLOOKUP(B2,ZipTable,2)

But I'm not sure how to have it find the row in which the lookup value falls
'between'.

Anyone able to help?? I hate to do this manually.

Thanks, Brian