Posted to microsoft.public.excel.misc
|
|
Data Validation & multiple columns
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
|