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