Just use the first column of numbers and then look in the help index for
LOOKUP. Answer will be 44100

--
Don Guillett
SalesAid Software

"confused about ranges" <confused about
wrote in message ...
I am trying to develop a routing guide to find freight rates for my company
and the trucking companies have provided zip codes in ranges. If I have
zip
code 44100 in cell A1, zip 44199 in B1, 44200 in A2 and 44299 in B2, and
different rates for those zips across columns C,D, E, and F, how do I
tell
Excel to find zip 44150? There is no specific 44150 zip. However, it
would
be found in the range between 44100 and 44199? The illustration below
might
make it more clear:

44100 44199 Find 44150
44200 44299
44300 44399