How to Create a Searchable Drop-down List in Excel скачать в хорошем качестве

How to Create a Searchable Drop-down List in Excel

In this video, I show you how to easily create a searchable drop-down list in Excel so users can enter a term in a search box that filters the results shown in the drop-down list. Note: If you’re using Excel 2019 or earlier, a Combo Box from the ActiveX Controls can provide a similar effect. Steps: 1 - create a list of options 2 - choose a cell for the search box 3 - use the FILTER function to generate search results · For partial matches: =FILTER(A2:A200, ISNUMBER(SEARCH(D1, A2:A200)), "") · For exact matches: =FILTER(A2:A200, A2:A200=D1, "") · For case-sensitive exact matches: =FILTER(A2:A200, EXACT(A2:A200, D1), "") 4 - create a named range for the filtered results list 5 - apply data validation to create the drop-down list Don't forget to subscribe to my channel for more tutorials! Check out my website at https://simplesoftwaretutorials.com Here's my list of home office essentials: https://www.amazon.com/shop/influence... Note: As an Amazon Associate I earn from qualifying purchases. Thanks for tuning in!