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]
[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]