Data Validation & multiple columns

B

Bob

In a Data Validation dropdown, is it possible to display more than one column
of data, but only "store" the value from the first column? For example,

Column A = Social Security Number
Column B = Last Name
Column C = First Name
Column D contains the Data Validation dropdown

When a user clicks on the Data Validation dropdown arrow, can the dropdown
box display the Social Security Number, Last Name, and First Name, but once a
person is selected, only "store" the Social Security Number in the cell?

Thanks in advance for any help.
Bob
 
Top