JazzSP8
Well-known Member
- Joined
- Sep 30, 2005
- Messages
- 1,227
- Office Version
- 2013
- 2010
- Platform
- Windows
Good Morning Guys
I was wondering if someone could help me with this problem.
I am creating a spreadsheet to measure general abscence, to include holidays and sickness, one of the things I would like it to do is measure someone's sickness and alert the user if someone has been sick more than four times in the year. To do this I need to be able to capture the first date that a sickness occours, below is a representation of my spreadsheet (sorry, can't download and install the HTML maker)
A B C D E F G
Agent Name Emp ID No Start Date Hours Entitlement Absence Type Date
Pinky 1890 04/12/01 37.5 15 Holiday 01/12/2005
Pinky 1890 04/12/01 37.5 15 Sickness 02/12/2005
Perky 2330 07/10/03 37.5 150 Sickness 03/12/2005
Pinky 1890 04/12/01 37.5 150 Sickness 04/12/2005
I want to be able to look though Column A for "Perky" and Column F for "Sickness" and return the value in Column G (03/12/2005)
I started out trying to get the value with a VLOOKUP but I couldn't find an example on how to make it check for more than one value, is there any other way I can do this?
Thanks in advance for any help that can be provided.
I was wondering if someone could help me with this problem.
I am creating a spreadsheet to measure general abscence, to include holidays and sickness, one of the things I would like it to do is measure someone's sickness and alert the user if someone has been sick more than four times in the year. To do this I need to be able to capture the first date that a sickness occours, below is a representation of my spreadsheet (sorry, can't download and install the HTML maker)
A B C D E F G
Agent Name Emp ID No Start Date Hours Entitlement Absence Type Date
Pinky 1890 04/12/01 37.5 15 Holiday 01/12/2005
Pinky 1890 04/12/01 37.5 15 Sickness 02/12/2005
Perky 2330 07/10/03 37.5 150 Sickness 03/12/2005
Pinky 1890 04/12/01 37.5 150 Sickness 04/12/2005
I want to be able to look though Column A for "Perky" and Column F for "Sickness" and return the value in Column G (03/12/2005)
I started out trying to get the value with a VLOOKUP but I couldn't find an example on how to make it check for more than one value, is there any other way I can do this?
Thanks in advance for any help that can be provided.