Show two fields in validation

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

When using Data/Validation/List/Source I am currently able to display only
one column of data. I want to display two columns/fields or combo box, is
this possible using Validation?

If not, do I need to us a Combo Box control? and if I do can you point me
to where I could see an example of a Combo Box being used in Excel.

Any help you can give will be much appreciated.

Pat
 
A data validation dropdown can only show one column of data. You could
combine the columns on the worksheet, and use the calculated column as
the source for the data validation list.

For example, combine data from columns A & B, and use column C as the
data validation source --
A B C
1 Code Product Data Val List
2 YYX ProductA =A2 & B2
3 TRX ProductB =A3 & B3
 
Back
Top