How to use Data Validation list with formulas using name range

[aliasger.q]

Hello Everyone,

Please anyone have an idea the problem i am facing how to resolve without using vba code.

For Problem Scenario Please check attachment jgp file,



now i want to do data validation list on j1 that showing 3 words (super dealer, dealer & retailer) that on selection on j1 showing result on cell k1 data validation list with 3 words (Gas, Deposit, & complete) then as same selection on cell k1 result should appear values like a2 to a5)

for simple understanding, i want data validation list on both the matching condition like super dealer with gas or super dealer with deposit or super dealer with complete set and so on.

thanks who give me any idea how i do this with using name range and data validation.

 

[bobhc]

You may find this link of help.

http://www.contextures.com/xlDataVal02.html


.

 

[aliasger.q]

Ohh my god!!!

It woks like charm!!!

Excellent link, thanks allot Mr.BOBHC(EXCEL NINJA)

but also having a problem in dependent data validation with dynamic data validation together,

i am trying but not working together.

for more information please see attachment

Note:Ref. hp to ig columns for calculation.