My excel file has a drop down list.I want to create a searchable drop down list in the detail sheet paddy variety coloumn.but my drop down list does not show the related items when I type a single letter in the drop down cell(D2 in detail sheet).I have used data validation without combo box.
Solved by O. J. in 28 mins