Hlookup and Vlookup with ranges

Hi,

Looking to get a formula that will give a certain percentage based on the name (column B) and the 15% based on the range the revenue achieved falls into.

As an example ... Julie Smith revenue for the month is 1150. She than falls into the 1100-1190 range giving her a percentage of 15%

Hope someone can help

Best
Rob

Try

Set headings in C2 onward as 0,1000,1100,1200,1300,1400,1500
in C10

=INDEX($C$3:$I$5,MATCH($C$8,$B$3:$B$5,0),MATCH($C$9,$C$2:$I$2,1))

Thanks John really appreciate it.... the only missing element is that when chanhing the revenue achieved, how does the formula change to another range e.g., what if the revenue achieved is 1450?

Apologies it does change ... spot on John

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.