V look up
 

I am trying to simplify my billing for winter plowing. this is what I am
looking to do
Sheet 1
Customer Name in cell A1 / Description of service say plow in cell B1 / # of
inches mind you the inches are usually 1-6 6.1-12 which will be in C1 / so
in cell D1 I would like the dollar amount.


Sheet 2

Plow Plow Plow Salt Calcium Shovel Shovel Shovel
Customer 1-6 6.1-12 12.1-18 1-6 6.1-12 12.1-18
Joe Smith $100 $160.00 $240.00 $115.00 $115.00 $115.00 $165.00
$215.00
Tom Smith $70 $120.00 $200.00 $75.00 $80.00 $40.00 $60.00 $80.00


Now these 2 customers are billed by the same inches some customers may be
billed 1-4 " 4.1-6" and so on how do i set up my formula to auto pop up my
cost for that service one I put into sheet 1.

I may not be explaining this very well but need help maybe you can simplify
the process

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