Forum

Notifications
Clear all

Display multiple column on dropdown list

3 Posts
3 Users
0 Reactions
62 Views
(@jdhimmar)
Posts: 8
Active Member
Topic starter
 

Hello,

How do I display column A and B on dropdown list? I currently only see Column A.  I would like to see Material# and Description on drop down list. 

Thank you for your help!

Jig Dhimmar

 
Posted : 21/09/2023 12:00 pm
(@keebellah)
Posts: 373
Reputable Member
 

Hi,

Can you tell us which version of Excel you're using?

 
Posted : 22/09/2023 2:04 am
Alan Sidman
(@alansidman)
Posts: 220
Member Moderator
 

Instead of a drop down box from data validation, use a combo box from the Developer Tab.  See tutorial 

https://www.youtube.com/watch?v=iqbv-TxLaJA

 
Posted : 22/09/2023 3:15 pm
Share: