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.
This was quite useful, thank you!
I'm glad you find it useful clarelass