drop down list/box that has formula built in for other cells
 

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

drop down list/box that has formula built in for other cells
 

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