Forum Discussion
Data Validation for Multi-Column Selection in Drop Down List
I have Sheet1 and Sheet2 tabs in my Excel spreadsheet. Sheet1 has data in columns A & B. Sheet1 column-A1 has a column header named Food Sheet1 column-B1 has a column header named Color There a...
Data Validation doesn't work that way, so it would require VBA to do what you want. That seems to be overkill to me.
The attached version shows a slightly different way:
It uses a helper column on the data sheet: