Lookup a result where value to find is between a range of values

[Phil]

Hi all ... I need a little help with this lookup.

I need to find a bonus percent from a table where total sales are between a
low and high value in the table.

Here's an example of the bonus table:
0 49,999.99 1%
50,000 99,999.99 2%
100,000 199,999.99 3%

The table is quite a bit longer than this, which is why I'd like to find a
formula to perform the lookup, rather than go the nasty
IF..ELSEIF..ELSEIF..ELSEIF.. route.

Thoughts anyone??

Thanks - Phil

 

[Frank Kabel]

Hi
try
=INDEX(C1:C100,MATCH(lookup_value,A1:A100,1))

 

[Aladin Akyurek]

=LOOKUP(SalesValue,BonusTable)

Or, equivalently...

=VLOOKUP(salesValue,BonusTable,2,1)

where BonusTable looks like this:

0 1%
50,000 2%
100,000 3%