Dear experts,
I have a burning question on the Index Match Match formulas.
I would like to have a formula in the highlighted yellow cells to help me match exactly the Origin-Destination lane and then approximate (round up) to the next weight interval; and return me the cost of that lane.
My understanding of Index Match Match is to look up in horizontal and vertical columns which would not be feasible for this case; since both look up values are in vertical columns.
Could any of you please advice on how I can do that?
excel.JPG
Bookmarks