Vlookup formula

[alexaa]

I need help on how to do a vlookup formula.. The question is to add a column named Water Bill to the table, and then enter a formula to calculate the water bill based on the following rules: The billing rate varies based on the type of customer (Cust Type column). The billing rate is $3, $2, or $1.50 per thousand gallons billed, depending on the customer type (see the lookup table in cells B2:C5 of the Billing Rate worksheet). For example, a commercial customer using 75,000 gallons has a water bill of $225 (75 x $3), whereas a government customer using 100,000 gallons pays $150 (100x $1.50). A commercial customer using 15,000 gallons has a water bill of $0n (see Gal Used rule in question 3).

 

[cval]

Hello,

You can try this formula:

=VLOOKUP(C2,$H$2:$I$4,2,FALSE)*B2

Where C2 contains the CUST TYPE, range H2:I4 contain the legend (Commercial = 3, Government = 1.5, etc) 2 = the value to return, and B2 the water used (in thousand gallons).

Good luck!

 

[alexaa]

C:\Users\Villalobos\Desktop\one.png

i still can figure it out, i send some pictures to see if you can see it for better help thanks

 

[BenMiller]

Sounds like you need an IF statement, not a VLOOKUP...

 

[alexaa]

i need to use the vlookup not an if statement tho

 

[BenMiller]

Why is that? With a VLOOKUP, you have to have the information entered already to pull it. You could write a simple nested IF to give you the price based on what is contained in the adjacent cell.

 

[alexaa]

my teacher wants a vlookup

 

[BenMiller]

Post a picture please, hard to understand exactly what you need from your description.

 

[alexaa]

i tried to but i dont know how to post a picture that is not on the internet on here???

 

[BenMiller]

Maye first post it to instagram.