Somewhere on your sheet you need to make a table with the machine
numbers in one column and the electric rates in the next column to the
right.

Eg. In E5 type your first machine number and in the cells below it
type your other machine numbers.
Now in F5 type the electric rate for that first machine number and in
the cells below type the rate for the machine in the cell of that row
in Col E.

Now in the cell where you want the electric rate to appear dependant
upon the dropdown value type this formula:

=VLOOKUP(B5,$E$5:$F$10,2,FALSE)
This assumes that your dropdown value is in B5 so change it to suit.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=396702