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'


Sukismomma wrote:
Hello!

I am creating and would like to have the following functionality within the
form.

I have the part description & part numbers on a separate worksheet in the
workbook.

I want to create a dropdown list on the invoice that lets me choose the part
description and will automatically fill the part number in the cell next to
it.

Help!
Thanks as always!


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