![]() “ Within_Text” – this is the cell or array of cells to be searched.“ Find_Text” – this is the text or cell holding the text to be located.The SEARCH function has three parameters: In cell D2, we will create a function to perform the search. When looking for all items that contain the letters “ GAR”, enter the letters “ GAR” in cell D1. This will keep us from having to switch back-and-forth between sheets during the development of the solution. NOTE: To simplify the demonstration, we will pretend that the Data Validation search list is in cell D1 of the “ MasterData” sheet. If an item exists multiple times in the source list, the dropdown list will display all items regardless of repetition.Īlthough all the above-mentioned issues are worth investigating, this post’s focus is on the searchable aspect of the Data Validation list. The list does not automatically suppress duplicate items.Locating a specific item in an unsorted list can be both tedious and time consuming, especially when the list contains hundreds or thousands of items. if new items are added to the list, the list does not automatically re-sort. What do we mean by a searchable Data Validation list? Let’s look at the example below.Ī traditional dropdown list provided via the Data Validation tool displays a list of items from a predefined list. This is a common question asked on this site and most any Excel training venue. ![]() “Does Excel have a feature to allow a Data Validation list to be searchable?”
0 Comments
Leave a Reply. |