View Single Post
 
Old 07-08-2010, 03:10 AM
mugezhn mugezhn is offline Windows XP Office 2007
Novice
 
Join Date: Jul 2010
Posts: 16
mugezhn is on a distinguished road
Default

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,
Reply With Quote