# How do you use the HLOOKUP? Confussed

#### susiesc

##### New Member
This is what I need to do: Use the Lookup table in cells E2:H3 of the billing rate worksheet and the HLOOKUP function to modify the formula to calculate the water bill column H.

 Type Com NPROFIT GOV Bill Rate \$ 3.00 \$ 2.00 \$ 1.50

<TBODY>
</TBODY><COLGROUP><COL span=4></COLGROUP>

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Robert Mika

##### MrExcel MVP
This is what I need to do: Use the Lookup table in cells E2:H3 of the billing rate worksheet and the HLOOKUP function to modify the formula to calculate the water bill column H.

 Type Com NPROFIT GOV Bill Rate \$ 3.00 \$ 2.00 \$ 1.50

<tbody>
</tbody>

to modify the formula
Which formula?
What's desired result is going to be?

#### riddenstudios

##### New Member
I'm confused. Are you using Hlookup to modify a formula? If your trying to look up a certain name or amount there's easier ways. If your trying to modify a formula you should be able to do it (in combo with other cells not in the lookup.)?

#### susiesc

##### New Member
Which formula?
What's desired result is going to be?

That is why I am confussed because I am told to create the report by using all of those formulas.
How are you suppose to do that when you are getting the information from another sheet?
Confussed....

#### susiesc

##### New Member
Which formula?
What's desired result is going to be?

That is why I am confussed because I am told to create the report by using all of those formulas.
How are you suppose to do that when you are getting the information from another sheet?
Confussed....

#### riddenstudios

##### New Member
I posted this on sheet1 to lookup billing rate, however as far as changing the value, you would need other funtion(s) or VBA to complete.

=HLOOKUP('Billing rate'!I2,'Billing rate'!E2:I3,'Billing rate'!3:3,TRUE)

Are you looking for something different?

#### Robert Mika

##### MrExcel MVP
That is why I am confussed because I am told to create the report by using all of those formulas.
How are you suppose to do that when you are getting the information from another sheet?
Confussed....
Which formula?
Can you post them?
Example of using HLOOKUP:

Excel 2010
ABCD
1TypeComNPROFITGOV
2Bill Rate\$3.00\$2.00\$1.50
3
Sheet1

Excel 2010
AB
1
2NPROFIT\$ 2.00
3
4
5
Sheet2
Cell Formulas
RangeFormula
B2=HLOOKUP(A2,Sheet1!\$A\$1:\$D\$2,2,0)

#### susiesc

##### New Member
Yes I need to lookup cells E2:H3 of the billing rate worksheet and then use the HLOOKUP function to modify the formula to calculate the water bill column (column H).

Replies
0
Views
583
Replies
6
Views
187
Replies
8
Views
377
Replies
1
Views
361
Replies
4
Views
8K

1,195,624
Messages
6,010,751
Members
441,568
Latest member
abbyabby

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back