Vlookup

L

Lanza52

Basically, I want to VLOOKUP a dropdown list.

In simpler terms. I want to do a dropdown list for option A.
The dropdown has A, B, C, D. If you pick A I want VLOOKUP to brin
forth another dropdown list to show options A1, A2, A3 and A4.

Cell A1. Validation, List, =ChoiceA-D.
Cell A2: VLOOKUP(A1,Choice1-4,2,0)

Cell D5 through D8: Named group ChoiceAthroughD
D5: A
D6: B etc
Cell D5 through D8 and E5 through E8: Named group Choice1-4
E5: Validation, List, =ChoiceA1-A4

This would have cell A2 lookup whats in cell A which is a drop dow
list with A1 through A4. However it isn't giving me the dropdown list
only what I have selected in the dropdown at E5.

Anybody know how to fix this, or could tell me if its possible or not.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent dropdowns 4
Drop down list 4
Using two Vlookup in one Cell 1
Formula in dropdown list 2
How to have conditional dropdown 1
Help w/Validation List & VLOOKUP 9
function to use to count value 9
Working out a value within a certain month. 14

Top