Hi
have a look at VLOOKUP for this. Use your drop down result
as lookup value.

-----Original Message-----
Please somebody help me!!
I am trying to set up an automated quote in excel 97.
What I want to do is select an item from a drop down menu
and have all the other info automatically be filled in in
the adjacent cells. It doesnt sound like rocket science
but I cant get it right!!
.