| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Drop Down List | Excel Discussion (Misc queries) | |||
| Dynamic Date Drop-down List | Excel Worksheet Functions | |||
| How to feed dynamic information to a drop down List (Validation Feature)? | Excel Worksheet Functions | |||
| Dynamic Drop Down List | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Hybrid Mode
