how to contruct formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

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

Similar Threads

Date Formula 85 factor 7
Need help ( Hope i made it clear this time) 1
Annual Leave automatic calculation 2
calculating Leave 12
formula Help 2
Excel Formula 7
Total Gratuity days to pay 1
Similiar data on two different sheets - how to ID what is differen 8

Back
Top