Index Match issue

ABC123

Having issues with the Index Match formula. Formula is successfully pulling information from the correct column on the referenced sheet that I want, but it is defaulting to only pulling the last row of information instead of the line that aligns with the name I would like. My formula is as follows: 

=INDEX({RRA Range 8}, MATCH("[Team 1]2", RRA Range 7}, 1))

RRA = referenced column in another sheet

[Team 1]2 = Cell on primary sheet which I linked to the reference sheet giving the name I want to match.              

Using the 1 on the end returns me the last row of info for the correct column, when I use 0 or -1 it returns #NO MATCH

Paul Newcome

Remove the quotes from around [Team 1]2 and then switch the match type to 0.