为什么索引/匹配不工作?

In the attached spreadhsheet, I am trying a straight forward index match with data in another sheet. I cannot figure out why the formula only works for some entries and returns mismatches for others. Does anybody have any thoughts?In the attached spreadhsheet, I am trying a str