You can use the Vlookup() function to fill in the adjoining cells, where it
(Vlookup) will match the drop-down list selection by polling an existing
datalist, which can be located in an "out-of-the-way" section of the current
sheet, or on a different sheet altogether.

Check out this web page of Debra Dalgleish for instructions.

http://www.contextures.com/xlFunctions02.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"juggernaught" wrote in message
...
I wish to automatically populate cells with static data when a selection is
made from a drop down list.

Say when 3000 is selected from the drop down list, I want the description
associated with 3000 to be automattically populated in the cell next to it.

I'm sure this is easy but.......