Multiple Column Data Validation

  • Thread starter Thread starter Hawke
  • Start date Start date
H

Hawke

I want to create a validation or a drop down list but want to see 3 colums
of my validation list.
is this possible?

On sheet 2 of my workbook I have a list of 3 columns and 600 rows. I want to
see all 3 columns but just return the value in column 1 to a cell in sheet1.

Roger
 
You could use a combo box from the control toolbox, to display the
multiple columns, and link the results to a cell.

If you want to use data validation, you could concatenate the three
columns on the worksheet, and use display that in the dropdown. Then,
use a change event to select the value from column 1.

I have a similar example under the heading 'Data Validation Change':

http://www.contextures.com/excelfiles.html
 
Back
Top