Index / Match Multiple columns from another sheet

Serena Williams
Serena Williams ✭✭✭
edited 12/09/19 in Formulas and Functions

I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the team information.

When I add a name to the new sheet, I assign that name to a team. I'd like all the additional information related to that particular team to populate in the appropriate columns. Please see screenshots below.   

Any assistance is greatly appreciated. 

Serena 

 

 

 

Resource Table.PNG

Roles.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!