CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Falcon4ch
Falcon4ch

Reputation: 120

Can you create a dropdown in Google sheets using a vlookup?

I have a sheet that looks similar to this:

enter image description here

Is it possible to create a formula in column B that will create a dropdown with the options from columns D through F and reference the selection in column A to find the values? Thank you!

Upvotes: 0

Views: 1247

Answers (1)

Brian Samson
Brian Samson

Reputation: 116

Understood.

Use a helper column and add the following formula:

=IFERROR(TRANSPOSE(query(C1:F3,"SELECT D,E,F WHERE C = '"&A1&"'")),"")

Then at B1, select "List from a range" in data validation dialog and enter the following in criteria:

=$I$2:$I$14

Link to example: https://docs.google.com/spreadsheets/d/1qAd7WFUjkMBTgxheoLRjG_RHXBplwg_qMSmXAbOsC1s/edit?usp=sharing

-Prior answer- I would use a helper column.

B1: =TRANSPOSE({C3:F3,C4:F4,C5:F5})

Then simply reference B1:B.

Upvotes: 1

Related Questions