Beatrix
08-14-2013, 09:37 AM
Hi Everyone ,
I don't know why below formula is not working:doh: I press Ctrl+Shift+Enter but it's not working. Any ideas??:think:
=INDEX(Attendance!$F$2:$F$471,MATCH(1,((Attendance!$A$2:$A$471=$B$2)*(Atten dance!$D$2:$D$471=B8)),0))
Cheers
Yeliz
I don't know why below formula is not working:doh: I press Ctrl+Shift+Enter but it's not working. Any ideas??:think:
=INDEX(Attendance!$F$2:$F$471,MATCH(1,((Attendance!$A$2:$A$471=$B$2)*(Atten dance!$D$2:$D$471=B8)),0))
Cheers
Yeliz