I have a State to State price matrix for transportation discounts by lanes between states. I've been able to get the max value utilizing the following. =MAX('Carrier1:Carrier8'!K4:K4) in each cell within the "Main Eval Discount" worksheet for best discount.
In the next matrix worksheet "Main Eval Carrier" I need to identify what carrier sheet (i.e. Carrier Name) corresponds to that highest discount in each cell.
The matrix is 147x147 cell square.
I've seen several examples for ranges but can't seem to get them to apply to my situation. Obviously operator challenged.
Any help will be very much appreciated.
Bookmarks