JEH105
New Member
- Joined
- Oct 11, 2019
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
I built a PTO calendar dashboard where it automatically updates the employees availability for the day based on the calendar's data. The options vary from U (unscheduled), holiday, jury duty, covering, or a value over 1 is added. This is what it looks like:
=IF(OR(VLOOKUP(N28,table info,6,0)="U",
VLOOKUP(N28,table info,6,0)="Holiday",
VLOOKUP(N28,table info,6,0)="Jury Duty",
VLOOKUP(N28,table info,6,0)="Covering",
VLOOKUP(N28,table info,6,0)>=1),"Time Off","Available")
*N28 is the the cell where the current date is located.
The issue is, that it doesn't distinguish the text. There is another text included in the data "Coverage N/A" and it counts it, it should be ignores as it is not included in the formula (or so I think). I tested and added random text "blah" and it would also mark the employee off for that day. It just doesn't actually distinguish the text, it counts any type of data on the cells.
Does anybody know what I'm doing wrong and what I can do to fix it? I truly appreciate any help!
Sincerely, an amateur. ? *sigh*
=IF(OR(VLOOKUP(N28,table info,6,0)="U",
VLOOKUP(N28,table info,6,0)="Holiday",
VLOOKUP(N28,table info,6,0)="Jury Duty",
VLOOKUP(N28,table info,6,0)="Covering",
VLOOKUP(N28,table info,6,0)>=1),"Time Off","Available")
*N28 is the the cell where the current date is located.
The issue is, that it doesn't distinguish the text. There is another text included in the data "Coverage N/A" and it counts it, it should be ignores as it is not included in the formula (or so I think). I tested and added random text "blah" and it would also mark the employee off for that day. It just doesn't actually distinguish the text, it counts any type of data on the cells.
Does anybody know what I'm doing wrong and what I can do to fix it? I truly appreciate any help!
Sincerely, an amateur. ? *sigh*