Thread: Lookup ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Graham is offline
external usenet poster
 
Posts: 155
Default Lookup ?

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 !