Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I populate a drop down list from Data Validation?
I proposed this equation in cell A3: =IF(A2="John",NAMES)
John being the words that populate A2 and NAMES being the name of the list created. For the sake of the example, the list NAMES contains Smith, Jones, and Williams. The problem is, instead of populating the full NAMES drop down, the cell only populates the first cell involved in the drop down (i.e., Smith). It gives me no option to select one of the names in the drop down. Is there a way around this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I populate a drop down list from Data Validation?
Select the cell where you want the drop down list to appear
Goto the menu DataValidation Allow: List Source: =IF(A2="John",NAMES) OK out If A2 does not contain John the drop down will not allow any selections. -- Biff Microsoft Excel MVP "Brian" wrote in message ... I proposed this equation in cell A3: =IF(A2="John",NAMES) John being the words that populate A2 and NAMES being the name of the list created. For the sake of the example, the list NAMES contains Smith, Jones, and Williams. The problem is, instead of populating the full NAMES drop down, the cell only populates the first cell involved in the drop down (i.e., Smith). It gives me no option to select one of the names in the drop down. Is there a way around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation with Drop-down list | Excel Worksheet Functions | |||
Data Validation Drop-Down List | Excel Discussion (Misc queries) | |||
DROP DOWN LIST DOES NOT APPEAR USING DATA VALIDATION | Excel Discussion (Misc queries) | |||
Populate a column of data with a formula using a drop down list | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel |