automatically update data validation selections

[dahill00]

I've restricted user enter for certain cells to a named range. Fo
example, the named range includes: Apples, Oranges, Bananas.
Let's say a user selects "Apples". Then, the list is updated so tha
"Apples" becomes "Green Apples". I want what the user selecte
("Apples") to now automatically reflect "Green Apples". I canno
figure out how to accomplish this without using a combo box - but
really don't want to use a combo box - just keep the user entry area a
cells.

Any suggestions with no code or a minimum of code are much appreciated
Thanks

 

[Frank Kabel]

Hi
one approach:
1. create your list with two columns:
- column A: ID for your entry
- column B: the associated name e.g. Apples

2. Now use a technique describe on the following site
http://www.contextures.com/excelfiles.html#DataVal (look for: Data
Validation "Columns") But change this so you fill in only the ID in the
data validation cell

3. In the associated column Use VLOOKUP to get the associated value

Now if you choose the name the associated value next to the drop down
should automatically reflect the new name