Hi
Have a look at the VLOOKUP function to solve this issue.

If your drop down data is in A1, you could use the VLLOKUP in B1 as follows.

=VLOOKUP(A1,range,2, FALSE)

where A1 is your reference data, range is the cells where your lookup data
is stored, 2 is the column that holds your description and FALSE forces the
formula to only give a result if there is an exact match.

HTH
Michael

"juggernaught" wrote:

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.......