drop down list from multiple colum

[EJA]

hi
how to make dropdown list from multiple rows
sheet 1 sheet 2
dropdown list colum b colum c
aai aa f
b b g
c c h
d d i
f
g
h
i

 

[Saurabhj]

Hi EJA,

The question is not clear. Please use XL2bb Tool to share your data and explain the requirement.

Meanwhile to create drop down list in excel, you can check below video:

3 ways to create drop down in Excel

Thanks,
Saurabh

 

[EJA]

thanks for your reply
is it works in excel 2016

 

[EJA]

i want to make searchable drop down list excel 2016