In the company I work for we have group managers who are responsible for
multiple locations. Each location has a 6 digit identification number. All
of the location numbers for a specific group are within a range of values.
An example of this is that all of the locations in Alabama are numbered
between 200500 and 299500.

What I need to be able to do is match a location number within that range of
values and return the group manager's name.

The look up table looks something like this:

Start End Mgr
200500 299500 Abe Alabama
300500 399500 Gordan Gulf
400500 499500 Tom Tennessee
500500 599500 Frank Florida
600500 699500 Grant Georgia
700500 799500 Eddy East

I tried using vlookup with "TRUE" in the "range_lookup" but it didn't quite
give me the results I wanted. Example is that if I try to look up a location
like 400000 it would be a closer match with "Gordan Gulf" and should be "Tom
Tennessee".
Formula I used was: =VLOOKUP(A2,Locations!A2:$C$7,3,TRUE)

In logical terms here is what I want to do:

IF location_number =start AND location_number <= end THEN lookup
group_manager

Any help you can provide would be appreciated.

Thanks so much,

Scott