Hello,
I have a transport matrix with give me transport cost to deliver different number of pallets to different area codes for several transport company.
In a separate sheet, I would like to have formulas which would give me the top 3 with company name and associated price, when the user enter the area code and the number of pallets.
I'm guessing I should use array formulas? I'm a bit stuck with the fact that I have one vertical criteria and one horizontal criteria...
Any help would be much appreciated
Pierre
I have a transport matrix with give me transport cost to deliver different number of pallets to different area codes for several transport company.
In a separate sheet, I would like to have formulas which would give me the top 3 with company name and associated price, when the user enter the area code and the number of pallets.
I'm guessing I should use array formulas? I'm a bit stuck with the fact that I have one vertical criteria and one horizontal criteria...
Any help would be much appreciated
Pierre
Attachments

13.8 KB Views: 7
Last edited: