Index / Match Multiple columns from another sheet
![Serena Williams](https://us.v-cdn.net/6031209/uploads/drupal_profile/files/pictures/e8/5c/ne85c115d28fb3e9d43add079df866532.jpg)
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
Comments
-
What is the formula you are currently using and what are the ranges covering?
-
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.
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!