how to contruct formula
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 |
how to contruct formula
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 |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com