Drop down list with Few independent column

[leakhna]

Hi Helper,

I would like to have a drop down list by set a condition if Column " L = D1 or D2 or D3 or D6, then the drop down list will show only the text content under their name." Example if L4 = D4 (the list in drop down will show only " Cha and Data".

Your supportive & kindness is very appreciated.

Thanks

[JohnTopley]

Create Named Ranges for D1 to D6

Excel will add"_" to name so it will be"D1_"

DV validation for L3: List ==Source: D1,D2 .....

DV for M2: List Source: =INDIRECT(L3 &"_")

[kvsrinivasamurthy]

Helper row 2 is used.
IN c2 copied across

=CELL("address",C4)&":"&CELL("address",OFFSET(C4,COUNTA(C4:C20)-1,0))

Formula for DV in M3

=INDIRECT(INDEX($C$2:$H$2,MATCH($L3,$C$3:$H$3,0)))