Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

Example

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

REF SHEET:
-------------------
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.

USER SHEET:
----------------------------
ACC | DATA | NUM#   |    AMT
--- | ---- | ------ | ------
AAA | wxyz | 1000 ▼ |
    |      | 1002   |
share|improve this question
1  
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
add comment

2 Answers

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

AAA-1000
AAA-1002

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
add comment

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
add comment

Your Answer

 
discard

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.