In Sheet2 column A languages has to be entered through drop down list but if I want to choose "Turkish" from drop down I need to scroll down until "T" letter comes, is there any possibility to search with letters and shows the match cases suggestions in the drop down list. Like if enter "T" it shows all languages having T...
please find the attachment and please do the needful...