Hi Everyone ,
I don't know why below formula is not working I press Ctrl+Shift+Enter but it's not working. Any ideas??
=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
Hi Everyone ,
I don't know why below formula is not working I press Ctrl+Shift+Enter but it's not working. Any ideas??
=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
Sub Learning VBA()
Do
Practice Most Useful VBA Examples
Loop Until Become an Expert in VBA
End Sub
Works here!
What do you get?
Does the combination of $B$2 and B8 exist?
It wouldn't be the extra space in
Atten dance
which should be
Attendance
would it?
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.