Index / Match Multiple columns from another sheet

Options
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!