Match function problems

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.

I few problems...

1. You have some trailing spaces in column A of Sheet1. Remove them.

2. Your lookup range starts at row 4, but should include row 3 too.

3. If you want to lookup multiple columns to return row number and you want to use MATCH, you need to do one at a time.

e.g. =IFERROR(MATCH(A2,Sheet2!$I$2:$I$20,0),MATCH(A2,Sheet2!$J$2:$J$20,0))

copied down.