How do you use the HLOOKUP? Confussed

[susiesc]

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.


[TABLE="width: 256"]
<TBODY>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Type</SPAN>[/TD]
[TD]Com</SPAN>[/TD]
[TD]NPROFIT</SPAN>[/TD]
[TD]GOV</SPAN>[/TD]
[/TR]
[TR]
[TD]Bill Rate </SPAN>[/TD]
[TD] $ 3.00 </SPAN>[/TD]
[TD] $ 2.00 </SPAN>[/TD]
[TD] $ 1.50 </SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=4></COLGROUP>[/TABLE]

 

[Robert Mika]

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.


[TABLE="width: 256"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Type[/TD]
[TD]Com[/TD]
[TD]NPROFIT[/TD]
[TD]GOV[/TD]
[/TR]
[TR]
[TD]Bill Rate [/TD]
[TD] $ 3.00 [/TD]
[TD] $ 2.00 [/TD]
[TD] $ 1.50 [/TD]
[/TR]
</tbody>[/TABLE]

to modify the formula

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

 

[riddenstudios]

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]

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]

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]

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]

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
	A	B	C	D
1	Type	Com	NPROFIT	GOV
2	Bill Rate	$3.00	$2.00	$1.50
3
Sheet1

Excel 2010
	A	B
1
2	NPROFIT	$ 2.00
3
4
5
Sheet2

Cell Formulas
Range	Formula
B2	=HLOOKUP(A2,Sheet1!$A$1:$D$2,2,0)

 

[susiesc]

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