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