I want to merge two index match in one formula however i am getting error
Formula 1:
=IF(INDEX(Working!$A$2:$D, MATCH(1,($A$5=Working!$A$2:$A)*($A$1=Working!$F$2:$F),0),2)=D4,"N",IF(INDEX(Working!$A$2:$D, MATCH(1,($A$5=Working!$A$2:$A)*($A$1=Working!$F$2:$F),0),3)=D4,"N",INDEX(Working!$D$2:$D, MATCH(1,(($A$5=Working!$A$2:$A)*($A$1=Working!$F$2:$F)),0))))
Formula 2:
=Index('Working2'!B3:B,MATCH(1,(('Working2'!A3:A=A5)*('Working2'!C3:C<=D3)*('Working2'!D3:D>=D3)),0))
does anyone have a solution for index/match ?
Sample of my Actual sheet
- Working
- Working 2
Sorry i forget to mention, but i am creating a roster please find the below link of sample file https://docs.google.com/spreadsheets/d/141S2xrPoZ4hAoSHjt5wUjD5Vs88Ar59O3ZUiL9UOnNc/edit#gid=1898322655