Hello

I am trying to create a drop down list. I can get list but I want to take
it a bit further. Example:

A1 will have a Drop Down List located in it. When I selecte a item in the
drop down I want it to put information assigned to in in another cell.
Example: Cell A1 will have a drop down list, If I selected 5 horse Power in
my list, I want 30 Amps to be placed in A2.

Thanks for any help
Terry

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'



Terry wrote:
Hello

I am trying to create a drop down list. I can get list but I want to take
it a bit further. Example:

A1 will have a Drop Down List located in it. When I selecte a item in the
drop down I want it to put information assigned to in in another cell.
Example: Cell A1 will have a drop down list, If I selected 5 horse Power in
my list, I want 30 Amps to be placed in A2.

Thanks for any help
Terry


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