Index Match issue

ABC123 ✭✭
edited 12/09/19 in Formulas and Functions

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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!