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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Validation rule for Combo Box 0
hide combo box 6
combo box - VBA form 3
data validation and combo box 4
How do I set up multiple fields in a list box? 3
Combo box formatting 2

Back
Top