Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup.


Here the data I'm using for reference. Notice "AAA" appears twice.

ACC | UNQ# |    AMT
--- | ---- | ------
AAA | 1000 | 100.00
BBB | 1001 | 100.00
AAA | 1002 | 200.00
CCC | 1003 | 100.00

Now when I type "AAA" in the ACC column I want the NUM# column to get a dropdown list of the array data (1000, 1002) returned where for example a VLOOKUP would return only one value. Once the NUM# value is selected by the user I can use a standard VLOOKUP function to populate the final AMT column.

ACC | DATA | NUM#   |    AMT
--- | ---- | ------ | ------
AAA | wxyz | 1000 ▼ |
    |      | 1002   |
share|improve this question
That's not possible with Google Spreadsheet, unless you use Google Apps Script (either in Google Spreadsheet or as a stand-a-lone script). But that will require you to make a user interface, create logic, knowing Google Apps Script......and more – Jacob Jan Tuinstra Jan 25 '13 at 20:43

Why not have a column that concatenates ACC and UNQ#, like:-


Then when AAA was typed in you would get the two options, then you can use SPLIT to get the UNQ# to do the second vlookup.

share|improve this answer

Why not use data validation with a dropdown? Make the user select from a range, your UNQ# column. If you want it to display only if something is entered in the previous column, use an empty check.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.