#1   Report Post  
ramana
 
Posts: n/a
Default 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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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   Report Post  
CILeader
 
Posts: n/a
Default



"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   Report Post  
CILeader
 
Posts: n/a
Default

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   Report Post  
ramana
 
Posts: n/a
Default Drop down list

thanks for the reply I'm working on it now.

Thanks

Ramana

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can you make a drop down list in a drop down list? Sburlingham Excel Discussion (Misc queries) 18 October 12th 09 07:58 AM
changing value of a cell by selecting an item from a drop down list Bobby Mir Excel Worksheet Functions 6 June 8th 05 08:33 PM
Pull unique names for drop down list [email protected] Excel Discussion (Misc queries) 3 February 1st 05 11:23 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 07:37 PM
Drop List Referencing Boony Excel Worksheet Functions 2 November 11th 04 12:42 PM


All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"