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.
I have followed the guidance below for an 9 column list where the the named cell is column 8, it is displaying correctly above the list, but the combo box return is column 1. I am missing something on the combo box "properties" menu, but don't have a clue.
Thx for the guidance, but I'm having a problem where I changed Bound Column=8 (out of 9) and the result in the combo box = column 1. The Named Cell is displaying correctly as column 8, but my combo box is displaying column 1. What am I missing?
This is good but i need some help on excel formula which is Index???
I'm glad you find it useful clarelass
This was quite useful, thank you!