
Rachid Malagouen
New Member
Members

Forum Posts: 1
Member Since:
September 3, 2022
September 3, 2022

Is there a way to bypass Excel error by using 2 columns for a drop down list. The drop down list shoukd appear as below:
A123 | Table 1 |
C452 | Chair |
Z458 | Bed 1 |
Z666 | Bed 2 |
A745 | Table 2 |
So I can list the code and the description of the code, because listing only the code (on the 1st column) is meaningless.

Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators
Power BI

Trusted Members
Moderators
Power BI

Forum Posts: 442
Member Since:
January 31, 2022
January 31, 2022

Hi Rachid,
You can't use 2 columns to create a data validation (i.e. drop down) list. The way to achieve what you need is to use the code only and then a lookup function in the adjacent cell. That may be VLOOKUP, XLOOKUP or INDEX/MATCH depending on your Excel version.
Riny
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 205
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
stuart burge
Bruce Tang Nian
Scot C
Othman AL MUTAIRI
Misael Gutierrez Sr.
Attif Ihsan
Kieran Fee
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Forum Stats:
Groups: 3
Forums: 24
Topics: 6223
Posts: 27295
Member Stats:
Guest Posters: 49
Members: 31920
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
