cell comparison

E

Elaine

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
 
J

JMB

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top