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