Why a script. Why not just use vlookup as a formula in a cell.

Assume the company name selected appears in B9

in a Sheet named data you have the company names listed in column A and the
description text in column B

in B10 you could have

=if(B9="","",Vlookup(B9,Data!A1:B200,2,False))

--
Regards,
Tom Ogilvy


"RobG" wrote in message
...
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.