I am creating team availability sheet. With the help of google till now i have created data as per Shift time and week off but i am trying to add another index match for leaves and it gives multiple errors
Screenshot of Agents master Sheet name Working
[Working]
Screenshot of Leaves master sheet name working2
[Working2]
Formula I am using to get week off and shift time :
=IF(B$4="","NA",IF(INDEX(Working!$A$2:$D, MATCH(1,($A5=Working!$A$2:$A)*($A$1=Working!$F$2:$F),0),2)=B$4,"N",IF(INDEX(Working!$A$2:$D, MATCH(1,($A5=Working!$A$2:$A)*($A$1=Working!$F$2:$F),0),3)=B$4,"N",INDEX(Working!$D$2:$D, MATCH(1,(($A5=Working!$A$2:$A)*($A$1=Working!$F$2:$F)),0)))))
Trying to combine this formula in the above one
=Index(Working2!$B$3:$B,MATCH(1,((Working2!$A$3:$A=$A$5)*(Working2!$C$3:$C<=B$3)*(Working2!$D$3:$D>=B$3)),0))
Error screenshot:
[error]
Please find the below Sample sheet for reference. https://docs.google.com/spreadsheets/d/141S2xrPoZ4hAoSHjt5wUjD5Vs88Ar59O3ZUiL9UOnNc/edit#gid=1898322655