Data Validation & multiple columns
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
|