Lookup function with drill down?
 

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!

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