All you need to do is set up a vlookup table. The first column of the
table will be the bottom threshold of each seniority grouping and the
second column will be the weeks of vacation. for each employee, you
would just enter a vlookup like this:

=vlookup(A1, D1:E5,2)
where A1 = years of service
and D1:E5 is the table described above.

Since you don't tell the vlookup to find an exact match, it will select
the value that is just less than A1 if there isn't an exact match.

Let us know if you have more questions, Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=488964