You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html

To return the related information for the selected item, you can use a
VLookup formula. There are instructions and examples he

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

There's a sample file that uses Data Validation and VLookup formulas he

http://www.contextures.com/excelfiles.html#Function

Under Data Validation, look for 'Order Form'


Laura wrote:
I am trying to create a formula so that the first cell, created as a
drop-down box, could be used to select a specific text. Based off the choice
selected, the next cell would have text entered automatically. For example,
from the drop-down cell box (A1) you would select the code, and the
subsequent cell (A2) would display its description.

What would my formula look like?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html