Prompt one value and output a different value using a data validation list

[vsardinas]

I a trying to create a list of words, then output an abbreviated word, based on the word chosen from the list.


Reason: I have a 30 character limitation to create a title (description) with.


Any help would be appreciated. Thank You Again for your time and effort.


VMS

 

[Hui]

Instead of using Data Validation List, can you use a Combo Box or List Box from Form Controls. These will return the index no of the selected value from the list and that can then be used to lookup an abberviation from a lookup table.

 

[vsardinas]

Thank you for responding. Just got home... First, I am not an Excel expert. So, I am not sure what I can and cannot do.


What I was trying to do is create a list that allows for words in the first part, and abbreviations in second part for line items noted.


format: line1, line2, line3 - line4, line5, line6

|_________________| |_________________|

a word an abbreviations


The Data Validation List works for the full word lines 1 - 3, since they will be used without becoming abbreviated. For lines 3 - 6 I want to show the words, but output the abbreviation for the word.


The goal is to describe the item, try and stay within a 30 characters, select the right word(s) to describe the item, limit the choice of words and abbreviations to items in a list(s), without having to remember all the abbreviations for the words.


Thank You Again,


VMS