Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
list choice depending on the value in another cell
I want to be able to change the list used in validaiton of a cell based the
value in another cell. Scenario, user selects a value in column A using validation list, cloumn B has If formula, I need column C to present one of 3 lists based on result in column B. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
list choice depending on the value in another cell
James,
http://www.contextures.com/xlDataVal02.html HTH, Bernie MS Excel MVP "James" wrote in message ... I want to be able to change the list used in validaiton of a cell based the value in another cell. Scenario, user selects a value in column A using validation list, cloumn B has If formula, I need column C to present one of 3 lists based on result in column B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
choice from a drop down list returns a result to a different cell | Charts and Charting in Excel | |||
Create a RowSource Depending on ComboBox Choice | Excel Discussion (Misc queries) | |||
Show pictures in excel depending of a choice! | Excel Discussion (Misc queries) | |||
add text to cell by clicking a choice in drop down list | New Users to Excel | |||
Calculate Value of Cell From Pick List Choice | Excel Discussion (Misc queries) |