How to use multiple columns (2 or 3) in ONE dropdown list created with Data Validation.
Not macro or VBA
How to use multiple columns (2 or 3) in ONE dropdown list created with Data Validation.
Not macro or VBA
Data validation doesn't have multi-column functionality. Multiple columns in drop-down lists require the use of combo or list boxes.
On the other hand, what do you want with several columns? Having several columns usually requires VBA to access them an utilise the information they contained. Since you specifically want to avoid VBA chances are that what you have in mind could be realised in some other way, perhaps even better. Care to elaborate?
Daddy knows best !