• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Searchable drop down List

TPR

Member
Dear Friends,
Appending a file where in sheet1 In Column A & Column C I need drop down list with searchable option without VBA.
I have list of fruits in "fruits" sheet.
Suppose in A2 when drop down list will appear there will be a search option with keyword search. If I write "apple" all words with apple will appear in drop down list, thereafter I shall select any one of those.
Please help.
Thanks in advance
Regards
TPR
 

Attachments

TPR

Member
TPR
Did You tried to search (top-right-corner) from this Forum?
There are many samples of that.
Friend,
Yes tried but couldn't find solution. There are few with VBA, few are asking for combo box. I need very simple solution. Can you help me ? Am not so strong in Excel.
Regards
TPR
 

vletm

Excel Ninja
TPR
Did You checked all these:

Your I need very simple solution. ...yes!
Test this from fruits-sheet cell A30.
 

Attachments

TPR

Member
TPR
Did You checked all these:

Your I need very simple solution. ...yes!
Test this from fruits-sheet cell A30.
Thanks for you simple solution. I am overwhelmed.
 
Top