View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
classic3283 classic3283 is offline
external usenet poster
 
Posts: 2
Default Matching a single value, with a value category.

I'm trying to figure out how I can easily match a list of numbers into a set
category.
For example. I have the number 11. I have the categories 1-10, 11-19,
20-29, ... and so on. Next to the value of 11, I want it to list the
category it's in (11-19). And for the number 86 below it, and the number 25
below that. Can anyone help me figure this out. I tried using VLookUp but
to no avail. Thanks in advance.