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

how to lookup a value within a range and return a label
 

Put these values in cells A1:B3

1 A
201 B
1001 C

put the value to look up in C1, and use this formula

=VLOOKUP(C1,A1:B3,2)


"jocmccoy" wrote:

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