Multiple dropdowns from same Origin

[Manny Singh]

Hi Excel Masters,

Got a query in relation to drop down, I want to create two different dependent drop down lists from same cell, I have described the query in sheet, please let me know if you need more info, thanks.

Cheers, Manny.

 

[narunfca]

Hi,

Simply Give Range Names for new set adding "_A" to it and give the list range name as =INDIRECT($B$2&"_A").

Like this any number of dropdown lists can be created.

Enclosed the Sheet for more info.

with best regards,

Arun N

 

[Manny Singh]

Awesome, thanks Arun, appreciate it.