Greetings;
I have a question I am hoping someone will be able to help me with. My
overall goal is to create a dropdown list with a line of data in it. When
selected only the second half of the line will be shown in the cell.

What I plan on doing is entering all of my data into two columns (first
column + second = dropdown list, second column = what is shown in the cell).
I would then create a drop down list from multiple columns. Using alot of IF
statements in VBA with a Private Sub Worksheet_Change(ByVal Target As Range)
program that would chage the entry from first column and second column to
only second column.

I have two questions-
1) Is it even possible to have a dropdown list based on two cells?

2) Is there an easier way than this? Since I have about 100 entries and
may want to add more later.

Thanks in advance for any comments or suggestions.
c