formula help

In cell c3 i created a drop down box to select which customer
In cell d3 i created a drop down list to be able to select task for that
customer.
In cell e3 i need to have a charge populated automatically based on customer
and task since each customer task is charged differently.

In cell h i list the customer say Tom 12 times going down so that can in cell
i list the task and then in J list the price for that task. what formula do
i need for that charge to automatically populate in cell e3

sample of what i want auto populated
c3 d3 e3 (this is what needs to auto populated
$'s from below list)
Tom Plow 1-6 $70.00

Ci2 j2 Tom k2Plow 1-6 L2 $380.00
ci3 j3Tom k3Plow 6.1-12 L3 $120.00
ci4 j4 Tom k4 Plow 12.1-18 L4 $160.00


this would go all the way down for the 12 tasks then I would put the next
customer down listing their tasks and $ amount. Maybe there is an easier way
please help

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200912/1