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

Hi,

Excel -- Data Validation -- Create Dependent Lists.

Use this URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu


"Bob" wrote:

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