Full a rating from one sheet to another


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))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!