CODEWITHSUNDEEP
google-sheetsdropdowngoogle-sheets-formula
Murtaza Abbasi
Murtaza Abbasi

Reputation: 87

Two-column cell list (Drop Down List) - Google Sheet

I need a Two-Column cell list (Drop Down List).

By default, we can only see single column of value in the cell list using the Data Validation option but I want to populate the list from two different columns. Please have a look at Example Table bellow...

Example Table:
| Column A   |     Column B   |
-------------------------------
| Sr. 1      | Product One    |
| Sr. 2      | Product Two    |
| Sr. 3      | Product Three  |

Now cell list be like;
​Sr.1 - Product One
Sr.2 - Product Two
Sr.3 - Product Three​

I want a single formula approach without using any tricks if possible...

Upvotes: 3

Views: 4633

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

I want a single formula approach without using any tricks if possible...

Because when using a formula Data validation does not allow an option for Show dropdown list in cell you will need a helper column with the following formula

=ArrayFormula(A2:A4&" - "&B2:B4)

enter image description here

Notes
The helper column could be anywhere in the sheet as well as hidden.
Please adjust ranges to your needs.

Upvotes: 5

Related Questions