Advance Drop Down

[skruege3]

I am sure this was covered in another topic, but can't find it. I am looking for something that if I select a state in column A (e.g - AL), i will then look up the branch and allow another drop down in Column B that would just give me the branches for AL.


Any help is appreciated.

				Table
State	Branch			State	Branch	Location Code
AL				AL	A	1
				AL	B	2
				AL	C	3
				AL	D	4
				AL	E	5
				MI	F	6
				MI	G	7
				MI	H	8
				MI	I	9
				MI	J	10
				MI	K	11
				MI	l	12
				MI	M	13
				TN	N	14
				TN	O	15
				TN	P	16
				TN	Q	17
				TN	R	18
				TN	S	19

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1974" width=54><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 1901" width=52><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><TBODY>
</TBODY>