Your sample table has logical problems!

I assume you meant this:

1 - 8499 = 0.12
8500 - 13499 = 0.14
13500 - unlimited = 0.16

Try this:

=IF(A1=13500,0.16,IF(A1=8500,0.14,IF(A1=1,0.12, "")))

--
Biff
Microsoft Excel MVP


"noodlehounds" wrote in message
...
I am looking for the formula to look up values/range in column A and
provide
the correlating value in column B

ie

A B
1 8499 0.12
2 8500 - 13499 0.14
3 13500 0.16

Thanks in advance!!!