how to contruct formula

E

Elaine

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
 
J

JMB

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.
 
Top