Hi,

There are two questions in your post, both very well solved by Debra

1. Data Validation Lists
http://www.contextures.com/xlDataVal01.html
and
2. Autocomplete
http://www.contextures.com/xlDataVal11.html