I am trying to create a template for our company's attendance policy where management just needs to input certain information into Excel and have it auto-generated into a Word template that they cannot edit.
I have them listing the attendance occurrences. I just can't find a formula that will help me determine the attendance rating based on the occurrences. I tried assigning points using the "IF" formula, but that got really confusing. Not sure how to use VLOOKUP for this...