Formula to replicate attendance Code in Calendar

[mmartinezq202]

Excel Forum,

I am working on creating an attendance tracker file and I am having a hard time right now. Here is the deal:

I have a sheet named "Occurrences" in which we will be entering the employee attendance records based on a code. For example: P=Present, U=Unexcused absence, NCNS = No call No show and so on... This code is placed on column E on that sheet.
What I would like to do is to replicate the attendance code found in that column/sheet to show in the attendance tracker which is in the sheet named "Attendance" based on the employee ID and Date.

For Example: The employee 119799 (Chow, Carlos) is showing as Present (P) on January 3rd. So, that means that on the sheet named "Attendance" the letter P should show on cell E8 only while the other cells should be blank (based on the occurrences tab) because we are taking into consideration the employee ID and the date. Other example is the following: The employee 119804 (Pineda, Jean) is showing as Critical work absent (CW) on January 20th, so that means that on the sheet named "Attendance" the letters CW should show on Cell V14 only while the other cells should be blank.

I am attaching the file I am working on. I really hope you guys can help me

Thank you for your usual support

[BadlySpelledBuoy]

In the attached is one simple method that uses a "helper column" (col K on the Occurences sheet) to create a unique reference that is used in an INDEX/MATCH lookup.

Hope that helps.

BSB

[mmartinezq202]

Thank you very much BadlySpelledBuoy !

Top of the notch. That is exactly what I was trying to do. All was done with a simple step. I am marking down this thread as resolved. I have already added reputation to you!

Thank you again