For example 0-9 hours bonus $100, 10-19 hours bonus $200, more than 19
hours, bonus $300
A1 = 0, A2 = 10, A3 = 20, B1 = 100, B2 = 200, B3 = 300, C1 = hours worked.

=VLOOKUP(C1,A1:B3,2)

Tyro


"IHateComputers" wrote in message
...
I have a question about a project that I don't understand, if anyone
could help that would be awesome!

Here is the question:

Consultants who work on a project also receive a bonus if the fees exceed
estimates, otherwise the consultant received no bonus. Create one formula
that calculates the bonus by referencing the appropriate bonus rate in the
table given by
the number of hours the consultant worked.

Does this make sense to anyone? I really need help. I fthis requires a
vlookup, can someone help me set it up?