I have a spreadsheet with employee names and years of service

Jane 4.65
Joe 2.50
Jill .85

I have data that indicates years and days
1 15
2 16
3 17 I need some form of formula that will allow me to search
the grid and place the correct number of days off by the number of years
service

See answer to previous post.

Does VLOOKUP not return the result you're looking for? Without specific
cell references (where the lookup table is and where your employee
names/years of service are) cannot give you a more specific solution
w/specific range addresses.

Also, what happens for employees w/less than 1 year of experience? You may
need to enter an additional line in your lookup table for 0 years.



"Elaine" wrote:

I have a spreadsheet with employee names and years of service

Jane 4.65
Joe 2.50
Jill .85

I have data that indicates years and days
1 15
2 16
3 17 I need some form of formula that will allow me to search
the grid and place the correct number of days off by the number of years
service