Lookup & Dropdown Problem, Please help!!

[stephen.smith]

Hey Guys,
I have a database where In column A I have a data validation dropdown with 4 options "List 1, List 2, List 3 & List 4". I then also have in Columns F,G,H & I The titles in Row 1 of "List 1, List 2, List 3 & List 4" and in 4 rows below each title 4 different fixed values under each list. I would like in Column B to be able to have a dropdown box that is populated with the corresponding values from each list dependant on the choice made in column A.

How do I do this??
Any help appreciated.
Thanks
Stephen

Sheet1

*	A	B	C	D	E	F	G	H	I
List Number	DROPDOWN	*	List Number	*	List 1	List 2	List 3	List 4
*	??Formula??	*	List 1	*	A	E	I	M
*	*	*	List 2	*	B	F	J	N
*	*	*	List 3	*	C	G	K	O
*	*	*	List 4	*	D	H	L	P

<tbody>
[TD="bgcolor: #CACACA, align: center"]1
[/TD]

[TD="bgcolor: #CACACA, align: center"]2
[/TD]

[TD="bgcolor: #CACACA, align: center"]3
[/TD]

[TD="bgcolor: #CACACA, align: center"]4
[/TD]

[TD="bgcolor: #CACACA, align: center"]5
[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

 

[James006]

Hi,

For dependent Data Validation, please have a look at Debra's solution :

Excel Data Validation -- Dependent Lists


HTH

 

[Stan_C]

Would you want to use Dynamic Validation or Dependent?

Also do you need D:D or is that how you create your Validation list?