I have several vertical ranges of zip codes with each range equaling a specific delivery cost. If I type the a zip code in one cell, I want the cell next to it to show the price of delivery. I have been successful with different formulas, but they have only worked with one range at a time. I can't get my multiple ranges nested correctly in the cell I want to display the cost. So basically I'm going about it this way, If this cell equals a number in this range, then return this value, if not return nothing. What would be the best way to approach this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Finding the correct formula for multiple ranges of zip codes to determine shipping cost.
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
