ExcelBanter - Dynamic drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Dynamic drop down list (https://www.excelbanter.com/excel-worksheet-functions/246813-dynamic-drop-down-list.html)

Bala

Dynamic drop down list

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

Dynamic drop down list

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
---------------
Jacob Skaria

"Bala" wrote:

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

Eduardo

Dynamic drop down list

Hi,
You need Data validation look into Debra web

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

"Bala" wrote:

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

All times are GMT +1. The time now is 03:33 AM.