V look up

  • Thread starter Darts via OfficeKB.com
  • Start date
D

Darts via OfficeKB.com

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top