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.
Bookmarks