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 bring
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 down
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.


--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316
View this thread: http://www.excelforum.com/showthread...hreadid=573463

http://www.contextures.com/xlDataVal02.html
--
paul

remove nospam for email addy!



"Lanza52" wrote:


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 bring
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 down
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.


--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316
View this thread: http://www.excelforum.com/showthread...hreadid=573463

Thanks, exactly what I was looking for.


--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316
View this thread: http://www.excelforum.com/showthread...hreadid=573463