Error on complicated Vlookup/GetPivotData Formula

[manny88]

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