Lookup function with drill down?

[Guest]

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]

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

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 here:

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

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

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

Under Data Validation, look for 'Order Form'