Data Validation
 

Is it possible to show the values in column B&C, but post the value in
column A when using Data Validation.

For example, Column B has Last Name, Column C has First Name, Column A has
Social Security Number.

The person clicks the combo box, the list shows Last Name, First name sorted
decending. He selects a name and the SS# shows up in the field.

The worksheet that will have the list of employees is entitled "Employees".

Thanks

Just starting here.