Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use "list" function within "IF" function
I have a drop down in column A and would like to display a particular list in
column B based on the selection in Column A. Eg. In column "A" I have a drop down list with these options: Acura, BMW, Audi .... etc. In column "B" I would like to display a dropdown list of: TL, TSX, RX if column A has Acura, a dropdown list of: A4, A6, A8 if Audi is selectedis column A, a dropdown list of: 3 series, 5 series, 7 series if BMW is selected in column A. Please let me know if this possible? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use "list" function within "IF" function
See
http://www.contextures.com/xlDataVal02.html In article , chineshg wrote: I have a drop down in column A and would like to display a particular list in column B based on the selection in Column A. Eg. In column "A" I have a drop down list with these options: Acura, BMW, Audi ... etc. In column "B" I would like to display a dropdown list of: TL, TSX, RX if column A has Acura, a dropdown list of: A4, A6, A8 if Audi is selectedis column A, a dropdown list of: 3 series, 5 series, 7 series if BMW is selected in column A. Please let me know if this possible? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use "list" function within "IF" function
Have you tried a lookup table?
If you put your data in columns then hide them ie, column d row 1 - row 4 you have Acura TL TSX RX column e row 1 - row 4 you have Audi A4 A6 A8 column f row 1 - row 4 you have BMW 3 Series 5 Series 7 Series If you wish to lookup up whats is say A2 , in cell c2 place the following, =HLOOKUP($A$2,$D$1:$F$4,2) cell c3 =HLOOKUP($A$2,$D$1:$F$4,3) cell c4 =HLOOKUP($A$2,$D$1:$F$4,4) You can then hide columns c,d,e and f If column B place you drop down list looking at data in column C. This allows you to easier update car data lists and to add more models etc. Hope this is what you was after. -- This post was created using recycled electrons! "chineshg" wrote: I have a drop down in column A and would like to display a particular list in column B based on the selection in Column A. Eg. In column "A" I have a drop down list with these options: Acura, BMW, Audi ... etc. In column "B" I would like to display a dropdown list of: TL, TSX, RX if column A has Acura, a dropdown list of: A4, A6, A8 if Audi is selectedis column A, a dropdown list of: 3 series, 5 series, 7 series if BMW is selected in column A. Please let me know if this possible? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions |