| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link a conditional list in MS Excel Data validation?
Data Data Score Column1 Column 2
Column1 10 20 Column2 11 21 12 22 13 23 I have Column head Data and Data Score. Required information is available under Column1 and Column2. Data column is selectable thru Data-Validation List -Column1 and Column2 When I select Column1 in selection list under Data column, I should be able to select information available under Column1 in "Data Score" column.I need help in this regard. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I link a conditional list in MS Excel Data validation?
Use Data Validation with a type of List and a formula of
=IF(C1="Column1",Column1,Column2) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mig" wrote in message ... Data Data Score Column1 Column 2 Column1 10 20 Column2 11 21 12 22 13 23 I have Column head Data and Data Score. Required information is available under Column1 and Column2. Data column is selectable thru Data-Validation List -Column1 and Column2 When I select Column1 in selection list under Data column, I should be able to select information available under Column1 in "Data Score" column.I need help in this regard. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I link a conditional list in MS Excel Data validation?
Bob,
It worked. Thanks a lot. Regards Mig "Bob Phillips" wrote: Use Data Validation with a type of List and a formula of =IF(C1="Column1",Column1,Column2) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mig" wrote in message ... Data Data Score Column1 Column 2 Column1 10 20 Column2 11 21 12 22 13 23 I have Column head Data and Data Score. Required information is available under Column1 and Column2. Data column is selectable thru Data-Validation List -Column1 and Column2 When I select Column1 in selection list under Data column, I should be able to select information available under Column1 in "Data Score" column.I need help in this regard. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| Conditional Data Validation possible in Excel 2003? | Excel Discussion (Misc queries) | |||
| How do I make a Validation List in Excel, using data on a second | Excel Discussion (Misc queries) | |||
| Excel, Data Validation List | Excel Discussion (Misc queries) | |||
| "Data Validation from list" Pocket excel ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
