Create a Searchable Dropdown List | Sinokap IT Tech Sharing
Sinokap China IT Service KDB
In Excel, you can use data validation as a tool to present a predefined choice in a dropdown list. However, when you have a long list of information and you want to search a certain item in the dropdown list, it takes time to scroll through all the items in the lists.
Here is a tutorial for you to create a searchable dropdown list using the combo box control, just like google search.
The video is reproduced from the network.
If any infringement, please contact us.
The formulas you will need for the list
❖ SEARCH function
=Search($G$!,A2)
❖ ISNUMBER function
=ISNUMBER(Search($G$!,A2))
❖ COUNTIF function
=COUNTIF($B$2:$B2,1)
❖ IF function
=IF(B2=1,COUNTIF($B$2:$B2,1),"")
❖ INDEX function
=INDEX($A$2:$A$88,MATCH(ROWS($C$2:$C2),$C$2:$C$88,0))
❖ IFERROR function
=IFERROR(INDEX($A$2:$A$88,MATCH(ROWS($C$2:$C2),$C$2:$C$88,0)),"")
PAST REVIEW
Introduction to Ishikawa Diagram
Combine Excel Files into One
Sinokap offers a full range of IT services to clients in different industry, scale and business nature, including IT on-site service delivery, IT outsourcing services, IT infrastructure services, IT consulting services for end user computing, Server Maintenance, Microsoft service, Linux service, Cisco Network Maintenance and etc. Please feel free to contact us if you have any IT problem.
Please feel free to contact us for any China IT Support requirements. Sinokap Shanghai will provide Professional IT service for you.
如您有任何中国IT服务支持需求，请随时联系我们。Sinokap上海鸿泷信息致力于为您提供专业高效的IT服务。
Contact Us
E-mail: service@sinokap.comHotline: 400-608-5168Website: www.sinokap.com