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