When using a data validation list, only one column of data is displayed, but sometimes there is a requirement for additional columns to be displayed simultaneously.
For example, sometimes you may have a list of products that have the same description but different colours and sizes. In this tip, we will take you through the steps of how to create a multi column data validation list.
Download the workbook to practice.
Your multi column drop down list is all setup and ready for use.
Its copying the Product description but not the code colour and size.
Agreed - the product Code would be more useful. If the ProductList ComboBox property 'Bound Column' is changed to '2' then the Product Code is stored in the 'ProductName' cell that was initially defined. If the color and/or size are needed in other cells, vlookup functions can be used to find the value in the ProductTable based on the unique code stored in 'ProductName'. It would make more sense to me if the 'ProductName' cell was actually named 'ProductCode' and referred to as such in the ProductList ComboBox 'Linked Cell' property, but that's just for clarity, not functionality. Hope this helps!