Log In
Register
Home
Drop Down List
Rachid Malagouen
New Member
Members
Forum Posts: 1
Member Since:
September 3, 2022
September 3, 2022
Offline1
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
Moderators
Moderators
Forum Posts: 1046
Member Since:
January 31, 2022
January 31, 2022
Offline2
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)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 925
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 343
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Hiroyuki Murai
Mark Allen
Yves Gagnon
PATRICK WALTER
Carley Brice
Ash Rahman
Christelle Lamprecht
Wei Kwok Tey
Partha Pratim Nandy
Inge Rousseau
Forum Stats:
Groups: 3
Forums: 25
Topics: 7087
Posts: 31062
Member Stats:
Guest Posters: 49
Members: 34503
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —