I have 2 data validation cells I want the second cell to equal certain words
in the list if the first data validation cell is selected to certain words.
the key is there are a lot of names in the first list but I would like to
have it use a common word with all the names like mr or mrs to change the
second data cell instead of reffering to the whole name.

Sounds like you want second list items to be dependent upon the first list
selection.

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal02.html

Also you seem to be describing some type of Autocomplete.

See Debra's site for that also.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 08:32:18 -0800, Robzz
wrote:

I have 2 data validation cells I want the second cell to equal certain words
in the list if the first data validation cell is selected to certain words.
the key is there are a lot of names in the first list but I would like to
have it use a common word with all the names like mr or mrs to change the
second data cell instead of reffering to the whole name.