Lookup Formula

[Donne]

I have an Excel sheet that shows hourly rates based on
the number of hours a customer purchases.

Example

Column A Column B Column C
(Hours)From: (Hours)To: Hourly Rate
1 40 $35
41 80 $32
81 120 $30

I have a seperate column under a different tab where a
sales rep enters the total number of hours. I would like
the formula to automatically lookup the chart above and
show the appopriate hourly rate.

Thanks,

Donne

 

[Lanwench [MVP - Exchange]]

Hi - best to ask the Excel gurus in an Excel newsgroup - this one is for MS
Outlook.

 

[Philippe L. Balmanno]

microsoft.public.excel.functions is the news group you need.