Error on complicated Vlookup/GetPivotData Formula

Hi, I am trying turn a rota into an automatic rota where it fills itself when data is dumped into another worksheet and updated via pivot tables. Thier shifts are already pre-set from another worksheet with shift codes linking to the rota tab via vlookup.

The outcomes on the rota are; in, late, sick, awol, unpaid and rdo (rest day off) - whilst referring to the relevant dates... my formula returns errors or #value. Below are 2 formulas I tried. I don't have the file to share as it is at work on not allowed. What Am I Doing Wrong???

1-- =IFERROR(GETPIVOTDATA("Agent Name",'Absence Log'!$F$1,"Agent Name",$D16,"Type","AWOL","Date of event",MV$5),IFERROR(GETPIVOTDATA("Agent Name",'Absence Log'!$K$1,"Agent Name",$D16,"Type","Sick","Date of event",MV$5),IFERROR(GETPIVOTDATA("Agent Name",'Absence Log'!$P$1,"Agent Name",$D16,"Type","Unpaid","Date of event",MV$5),IF(GETPIVOTDATA("Agent Name",'Late Pivot'!$A$1,"Period",MV$5,"Full Name",$D16,"in","To look at"))))


2-- =IF(VLOOKUP(MS15,'Shift Codes'!A:L,7FALSE)="RDO","RDO",IFERROR(GETPIVOTDATA("Agent Name",'Absence Log'!$K1$,"Agent Name",$D15,"Type,"Sick",Date of event",MU$5)>0,"sick"),IFERROR(IF(GETPIVOTDATA("Agent Data",'Absence Log!$F1$1,"Agent Name",$D15,"Type","AWOL","Date of event",MU$5)>0,","AWOL"),IFERROR(IF(GETPIVOTDATA("Agent Name",'Absence Log'!$P$1,"Agent Name",$D15,"Type","Unpaid","Date of event",MU$5)>0,"Unpaid",""),""))))

I will be so grateful to whoever could solve this

first thing i see in the first one is you have an IF statement at the end instead of an iferror
=IFERROR(GETPIVOTDATA("Agent Name",'Absence Log'!$F$1,"Agent Name",$D16,"Type","AWOL","Date of event",MV$5),IFERROR(GETPIVOTDATA("Agent Name",'Absence Log'!$K$1,"Agent Name",$D16,"Type","Sick","Date of event",MV$5),IFERROR(GETPIVOTDATA("Agent Name",'Absence Log'!$P$1,"Agent Name",$D16,"Type","Unpaid","Date of event",MV$5),IFerror(GETPIVOTDATA("Agent Name",'Late Pivot'!$A$1,"Period",MV$5,"Full Name",$D16,"in","To look at"),0))))

Hi, yes that was put there on purpose. Would taking that out take away the error and give me the return I am looking for, in theory?

Just FYI, They are not 2 separate formulas. They are 2 different attempts to return the desired values/text

im just looking at attempt one... the way you have your formula set up is get the pivot data for AWOL and if theres an error get the pivot data from SICK..etc etc until you get to the end where you have the beginning of an if statement stating "IF pivotdata to look at" with 0 logical statement and 0 true or false answers for the logical statement... Does my formula in my above post work? its hard to see if it works on my end because i dont have access to this workbook.