Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down list
Hi Everybody,
Ihave a question on drop down list. In the column A1:A4 I have descrition of items and in the column B,C,D, E I will have the volume of sales in the years(say 2004,2003,2002&2001). Now in cell A5 I created a dropdown list using validation in the data menu byselecting the range A1:A4, Now What I need is if i pick a an item from the drop down list it is displying the item in CellA5 I need the corresponding data to that item should be displayed in the cells B5,C5,D5,E5 automaticaaly, I need this because I use this as a input to the other formulas. Please help me out regarding this problem. Thanks & Regards Ramana |
#2
|
|||
|
|||
You can use data validation, and vlookup formulas to do this. There are
instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html http://www.contextures.com/xlFunctions02.html and instructions for an order form that uses this technique he http://www.contextures.com/xlOrderForm01.html ramana wrote: In the column A1:A4 I have descrition of items and in the column B,C,D, E I will have the volume of sales in the years(say 2004,2003,2002&2001). Now in cell A5 I created a dropdown list using validation in the data menu byselecting the range A1:A4, Now What I need is if i pick a an item from the drop down list it is displying the item in CellA5 I need the corresponding data to that item should be displayed in the cells B5,C5,D5,E5 automaticaaly, I need this because I use this as a input to the other formulas. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
"ramana" wrote: Hi Everybody, Ihave a question on drop down list. In the column A1:A4 I have descrition of items and in the column B,C,D, E I will have the volume of sales in the years(say 2004,2003,2002&2001). Now in cell A5 I created a dropdown list using validation in the data menu byselecting the range A1:A4, Now What I need is if i pick a an item from the drop down list it is displying the item in CellA5 I need the corresponding data to that item should be displayed in the cells B5,C5,D5,E5 automaticaaly, I need this because I use this as a input to the other formulas. Please help me out regarding this problem. Thanks & Regards Ramana |
#4
|
|||
|
|||
Everything that you did in creating the drop-down list is correct. Now all
you need to do in cells B5 - E5 is to add a"Vlookup" function to these cells. For example, in B5, the correct formula is: =VLOOKUP($A$5,$A$1:$E$4,2), where $A$5 locks in cell A5 as the reference cell, $A$1:$E$4 locks in the range of information in the "lookup" range of values, and the final value "2" says look up the value in the second column of the range of values. Copy this formula across the other cells (C5 - E5), then change the lat value "2" to the respective location value (e.g. in cell C5, the last value in the formula is "3": =VLOOKUP($A$5,$A$1:$E$4,3), and so on.....). "CILeader" wrote: "ramana" wrote: Hi Everybody, Ihave a question on drop down list. In the column A1:A4 I have descrition of items and in the column B,C,D, E I will have the volume of sales in the years(say 2004,2003,2002&2001). Now in cell A5 I created a dropdown list using validation in the data menu byselecting the range A1:A4, Now What I need is if i pick a an item from the drop down list it is displying the item in CellA5 I need the corresponding data to that item should be displayed in the cells B5,C5,D5,E5 automaticaaly, I need this because I use this as a input to the other formulas. Please help me out regarding this problem. Thanks & Regards Ramana |
#5
|
|||
|
|||
Drop down list
thanks for the reply I'm working on it now.
Thanks Ramana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |