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