Index / Match Multiple columns from another sheet

11/19/19 Edited 12/09/19

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

    thinkspi.com

  • 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. 

     

     

    Capture2_0.PNG

  • Paul NewcomePaul 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.

    thinkspi.com

Sign In or Register to comment.