| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a number between numbers in two separate columns
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Parce a number with decimals into separate columns | Excel Discussion (Misc queries) | |||
| find closest match to a reference number in a row of numbers | Excel Discussion (Misc queries) | |||
| Find similar numbers from two columns of numbers | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
