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).

 

[alexaa]

@araavilla

 

[BenMiller]

Sent request. Or post public link to picture here.

 

[alexaa]

there on instagram

 

[alexaa]

can you just give me an email where i can send it to you

 

[BenMiller]

can you just give me an email where i can send it to you

Yeah I did on Instagram. Email me the .xls file, not the picture.

 

[alexaa]

Sent the email; Thanks!

 

[BenMiller]

Sent the email; Thanks!

Did I resolve the issue well?

 

[alexaa]

I didnt recieve anything

 

[BenMiller]

I emailed it you hours ago .. just resent it.

 

[alexaa]

yes, thank you so much; also how do i highlight only the top 15 % of the Total bill amounts with a yellow background color. Filter the table so that only the top 15 percent are displayed. Sort the filtered table by largest to smallest