How to do an Index Match

Answers
-
@Brian_Richardson @Genevieve P.I have successfully created my unpivot tables thanks to the solution you have found.
I am now trying to use this sheet as a source for an index/collect formula on another sheet as per first screenshot
ive tried this and collect formula on its own but keeo getting error messages.
Are you able to advise please?
-
Hi @Paul Newcome hope you are well, wondering if you are able to help me with my last post on this thread please?
-
@MazU can you please take this out of this post about unpivot, since your question is about how to do an index match and not the unpivot? You can tag me in that post. Also please in that post share screenshots of your setup on both sides as well as your error and formula.
-
What is the error you are getting?
-
@Brian_Richardson sorry, not able to delete it and @Paul Newcome i managed to solve it. Thanks for getting back to me.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!