Pull the maximum price based on the Drop-down value in a price list

[Max_excel]

Hi Experts!

I want help in pulling up the maximum price based on the Drop-down value from a from price list. I am not sure if this can be done with VBA or with a formula. Below are the conditions:

1. If the user only selects the Country from the first drop-down then the maximum price should pull up for that country.
2. If the user selects both the country and a district, then the maximum price for the district should pull up.
3. If branch is also selected along with country and district, then branch price should pull up in the fields.

You can bring up the prices in rows 8 through 11 in Sheet1 and price list is in tab Data.

[PCI]

Have you ever seen to use pivot Table: See attached

[Max_excel]

I know pivot table but it cannot be used in my form.

[PCI]

See file attached.
Some names have been added and one changed : Country
Review carefully and comment

[Max_excel]

It works perfectly!

Thanks.

[PCI]

Good news
Have a great day