| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"If" statement
I have a cell in which the user can select a location. Based on the location
they select, I want a cell elsewhere in the spreadsheet to display only the sales personnel assigned to the location they've chosen (which is a validated list). I"m sure there's some "if" statement but I can't make it work. Help!In the instance below, if they choose the location US, I only want them to be able to select, for their s/p, Bob or Steve. Loc S/P 01-USA Bob 01-USA Steve 29-CAN Ken 29-CAN Mark Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" statement
hi
not sure but its sounds like you talking about dependent lists. see this site..... http://www.contextures.com/xlDataVal02.html regards FSt1 "smartgal" wrote: I have a cell in which the user can select a location. Based on the location they select, I want a cell elsewhere in the spreadsheet to display only the sales personnel assigned to the location they've chosen (which is a validated list). I"m sure there's some "if" statement but I can't make it work. Help!In the instance below, if they choose the location US, I only want them to be able to select, for their s/p, Bob or Steve. Loc S/P 01-USA Bob 01-USA Steve 29-CAN Ken 29-CAN Mark Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If" statement
See this:
http://contextures.com/xlDataVal02.html -- Biff Microsoft Excel MVP "smartgal" wrote in message ... I have a cell in which the user can select a location. Based on the location they select, I want a cell elsewhere in the spreadsheet to display only the sales personnel assigned to the location they've chosen (which is a validated list). I"m sure there's some "if" statement but I can't make it work. Help!In the instance below, if they choose the location US, I only want them to be able to select, for their s/p, Bob or Steve. Loc S/P 01-USA Bob 01-USA Steve 29-CAN Ken 29-CAN Mark Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining "IF"statement with "Vlookup" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| "IF" statement & "strikethrough" formatting | Excel Worksheet Functions | |||
Linear Mode
