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
Last edited: