Thread: Lookup ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
 
Posts: 57
Default Lookup ?

is there a lookup function that I can use to categorize a column

In Column Q I have a percentage for example
ColumnQ ColumnR
22% 21-30%
4% 0-10%

So in Column R I need a formula that looks in column Q and then give R a value
of either
0-10%
11-20%
21-30%
31% +