Excel Examples: Multiple Searchable Dropdown List

In this tutorial, you’ll learn how to create a searchable drop-down list in Excel. Not only that, you can make searchable drop-down list anywhere in the Excel sheet after watching the video. When clicking on a drop-down list cell, a list box will pop up with all drop-down items listed. Enter a character and the corresponding items will be searched out at once, and you can click the needed item to insert it into that cell. For a drop-down list with many values, finding a suitable value from the list is not an easy work. We have previously introduced a method to create drop-down list in a single cell. 

Suppose you have a list of country names and now you want to use them as the source data of the searchable drop-down lists, you can do as follows to get it done. In the vide, we have used ‘Name Manager’ option in this tutorial to create searchable dropdown list.

Following functions were used in the whole process-

1) SEARCH

2) ISNUMBER

3) IF

4) MAX

5) VLOOKUP

6) OFFSET

7) CELL

8) INDIRECT