cell comparison
I am trying to set up a formula in which I have a chart of number 1 - 15 to
equal the number of years service with a company. Beside it is the number of vaction days for each of those years. Example 1 year-15 days 2 years- 16 days etc. I have a spread sheet that includes names and years of service based on hire date. I want to have excel look at the list and from the list find the number of years and place the number of days in the column beside the number of years of service in the spread sheet. I think It will work, but I do not know what formulas to use and cannot understand enough of the directions listed |
cell comparison
check excel's help for VLOOKUP function:
If your table is named "vacation" and the years of service for a particular employee is in cell D1, the formula would look like: =VLOOKUP(D1,vacation,2,TRUE) "Elaine" wrote: I am trying to set up a formula in which I have a chart of number 1 - 15 to equal the number of years service with a company. Beside it is the number of vaction days for each of those years. Example 1 year-15 days 2 years- 16 days etc. I have a spread sheet that includes names and years of service based on hire date. I want to have excel look at the list and from the list find the number of years and place the number of days in the column beside the number of years of service in the spread sheet. I think It will work, but I do not know what formulas to use and cannot understand enough of the directions listed |
All times are GMT +1. The time now is 03:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com