Not an exact solution but you can use a drop down menu.
Choose the list of names, right click with mouse and select "Name a Range" and then give a name to the area you have selected; ie: NameList
Go to the cell which you want to do search. On the Data menu, choose Data Validation/Data Validation. Under Settings /Allow choose List.In Source write =NameList (or the name you have given)
Now you can choose from the menu the list of names.
BR,
|