Index / Match Multiple columns from another sheet

Serena Williams

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 

 

 

 

Paul Newcome

What is the formula you are currently using and what are the ranges covering?

Serena Williams

This is the formula I'm using to pull information in for one column. I can't figure out how to pull all columns without creating the same formula for each column. 

 

 

Paul Newcome

You have 2 options. You can either recreate the formula for each column and update the range, or you take advantage of specifying the column in the INDEX function by changing your range to cover all columns then update 1, 2, 3, 4, etc depending on which column you are trying to pull from.