Create a table somewhere with bottom of range and accompanying text

Years Service
0 <=1
2 2-5
6 6-10
etc.

then use

=VLOOKUP(B2,L1:M10,2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"GuinnessT" wrote in message
...
Hi,

I want to assign a group to each of my data columns

eg I have employees years of service and I want to add a group such as 1-5
years 6-10 years etc

Name Years of Service Group
J Blogs 2.5 1 - 5 years
S Smith 11 11-15 years

The only way I can think of doing it is by using IF statments to say if
the
value is between 1 and 5 put '1-5 years' etc but this would need more than
7
nested IF's and I have been told that if you need more than 7 there is a
better way of doing it!

Could a vlookup work and if so, how do you get it to look at values within
a
range?

Thanks