i need this formula in sheet how do i write this??
=IFERROR(IFERROR(LOOKUP(2,1/((All_Leave!$F$2:$F$100>=C$7)*(All_Leave!$E$2:$E$100<=C$7)*(All_Leave!$A$2:$A$100=$A8)),All_Leave!$G$2:$G$100),LOOKUP(2,1/((attendence!$B$2:$B$295=$A8)*(INT(attendence!$D$2:$D$295)=INT(C$7))),attendence!$I$2:$I$295)),"")