Dynamic drop down list

[Bala]

Hi,
I have two columns A and B as shown below. When I choose North in Col A, I
should get only values correspondig to North in Col B . ( 1,4,2 and 6). Can
you help me with the right formula?

Col A Col B

North 1
South 4
East 2
West 3
South 6
South 5
North 4
North 2
West 1
East 2
North 6

 

[Jacob Skaria]

Check out the topic "Excel -- Data Validation -- Dependent Dropdowns from a
Sorted List " by Debra Dalgleish

http://www.contextures.com/xlDataVal13.html

If this post helps click Yes

 

[Eduardo]

Hi,
You need Data validation look into Debra web

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