View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jocmccoy
 
Posts: n/a
Default how to lookup a value within a range and return a label

Wrecking my head this one:

For example if the Label
A is from 1 to 200
B from 201 to 1000
C from 1001 and above

How can I lookup and return the correct label for a value.

Is there a function for this, or does it require programming