View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
terry terry is offline
external usenet poster
 
Posts: 193
Default 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