how do I return a value between two other values from a table

[P Forbes]

Col A Col B Col C
Row1 $1,000.00 $2,500.00 10%
Row2 $2,501.00 $5,000.00 12%
Row3 $5,001.00 $10,000.00 15%
Row4 $10,001.00 $15,000.00 18%
Row5 $15,001.00 $20,000.00 21%
Row6 $20,001.00 $99,999.00 24%

Here's what I have.
I need to return the percentage for a value greater than or equal to Col A
and less than or equal to column B. For example, if the lookup amount is
$9,001, the percentage should be 15%. I'm not looking for an exact match,
but a range between column A & B that will return the value in column C. Any
help is greatly appreciated!

 

[eagleyzw]

you can use 'lookup'

 

[eagleyzw]

for example:
if the amount you want to lookup is 9001 in range E5

The formula is =LOOKUP(E5,A1:A6,C1:C6)

 

[T. Valko]

You had it right the first time! *Do use* the lower limits.

E1 = 9001

=VLOOKUP(E1,A1:C6,3)

Result = 15%

 

[T. Valko]

Here's a link to a sample file:

xSampleLookup.xls 14kb

http://cjoint.com/?griaEtaxYD

The lookup value in cell E1 is a formula generated random number from 1,000
to 100,000. Press F9 to generate a new number.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks, Biff