Excel Forum

Drop Down List

Rachid Malagouen

New Member

Members

Forum Posts: 1

Member Since:
September 3, 2022

Offline

September 3, 2022 - 9:03 pm

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

Forum Posts: 442

Member Since:
January 31, 2022

Offline

September 4, 2022 - 4:38 pm

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)

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