Full a rating from one sheet to another

Leann Gibson

Hello,

I am using the below to pull a rating from one sheet to another. I want the two sheets to look a the staff name, and then pull the rating over.

Example: Master sheet has Joe Smith (Full Name Team) with a rating of Far Exceeds Expectations. I need this rating to go into another sheet (just that cell) where I have Joe Smith listed with a lot more information.

=INDEX({Rating}, MATCH({Full Name Team}, {Full Name}. 0))

Melissa Yamada

Hi @Leann Gibson

Try this

=INDEX({Rating}, MATCH(Full Name@row,{Full Name Team}, 0))

Leann Gibson

@Melissa Yamada I am getting: #UNPARSEABLE

Melissa Yamada

Make sure that your cross sheet references are looking at the whole column in the source sheet. This might help

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Leann Gibson

Now I get, #incorrect Augment set

Rating is going to a sheet that populates from four different sheets to create one master by function/team.

The first full name points to that same sheet and the last one points to the sheet I want all teams (four different ones) to contain ALL staff ratings.

=INDEX({Rating}, MATCH({Full Name}, {Full Name@row}, 0))

Paul Newcome

Between {Full Name Team} and {Full Name}, which one is on the other sheet and which one is on the sheet that has the formula?

Leann Gibson

@Paul Newcome {Full Name Team} is the other sheet and {Full Name} is the sheet that has the formula, where I want the value to go.

Paul Newcome

Give this a try:

=INDEX({Rating}, MATCH([Full Name]@row, {Full Name Team}, 0))

Leann Gibson

@Paul Newcome you are my hero!!! What was I missing?

Paul Newcome

Happy to help. 👍️

Your syntax in the MATCH function was off. Your first piece should be the value to match on, second piece is the cross sheet reference telling it where to look for the match, and then you had a period instead of a comma between the second and third pieces of the MATCH function.