With the lookup value in C1 try the below formula. Format the cell to
percentage

=LOOKUP(C1,{0,10000,15000,20000,30000,40000,50000} ,{0,10,20,30,40,50,60})%

If this post helps click Yes
---------------
Jacob Skaria


"Graham" wrote:

Hi I have something like this:

A B
0-9999 0%
10000-14999 10%
15000-19999 20%
20000-29999 30%
30000-39999 40%
40000-49999 50%
50000- 60%

I NEED A FORMULAE TO GIVE ME THE % IN COLUMN B WHEN VALUE IS WITHIN THE
RANGE IN COLMN A.

THANKS
GRAHAM
--
Eager to learn !