Match function problems

[tradergreg]

I've spent at least two hours trying to figure out why this isn't working. It's driving me nuts.

I want to match text from one sheet and match it with text in another sheet, but it never seems to work where I need it. (I'm trying to build an index-match function to return numbers associated with the team, and it is the match portion that continues to fail)

Please take a look! I've greatly simplified it.