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. 





Resource Table.PNG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!