PDA

View Full Version : [SOLVED] lookup formula with multiple criteria



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

p45cal
08-14-2013, 11:08 AM
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?

Beatrix
08-15-2013, 04:21 AM
Thanks very much P45cal.:cloud9: 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:banghead: nasty database:devil2:


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?