Hi Everyone ,
I don't know why below formula is not workingI 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
=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.
Thanks very much P45cal.It was me. I didn't notice the format issue. b8 was in number format and the value in column D was in text format
nasty database
Originally Posted by p45cal
Sub Learning VBA()
Do
Practice Most Useful VBA Examples
Loop Until Become an Expert in VBA
End Sub
Posting Permissions
Reply With Quote
