2 List in 1 Drop Down

[vishal thakral]

Dear All,
We require multiple list in 1 drop down through data validation.

Kindly suggest.

Please refer attachment

Thanks in advance

 

[Faseeh]

Hello,

Please see attachement for workout. The formula has been adopted from Get Digital Help's following Link:

http://www.get-digital-help.com/2009/06/29/merge-two-columns-into-one-list-in-excel/

 

[vletm]

Something like this ...
just select that "E2"-cell to see dropdown
If need modify lists, then just add as many rows You need and ..
... select "E2"-cell
>>> Ideas ... Questions?