I am trying to create a script that allows me to select one option from a
long pull down list and automatically insert the corresponding text from the
next column in the source data into another cell. (Select the company
description code from the pull down list and the description text appears in
the cell below). I think it should be easy, but I am a bit of a beginner in
this area and this one keeps defeating me!

I am using Excel 2003.