Index Match
Hello All,
=IFERROR((INDEX((COLLECT({Annabelle Pruned}, {Client Name (Pruning)}, [Client Name]@row, {Annabelle Name}, "Annabelle"),1),0)
This formula I've used (with the help of the pro desk) elswhere under the same circumstances as the one above:
Anabelle pruned is a Boolean, Annabelle Name is a text box.
The error is unparseable.
You all are always so helpful. I wish I were in a position to reciprocate. :)
Thank you for your help in advance.
Best Answer
-
It appears that there's an inconsistency in parenthesis pairing. There are 5 ('s and 3 )'s. I did a quick test, and from what I did, if you replace the double (( on either side of INDEX with a single ( …issue solved. Of course you'll want to verify the ranges.
And if I may make a recommendation? Get super familiar with how COLLECT works. It'll be your best friend. 😀 See this link for more information about the function:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Answers
-
It appears that there's an inconsistency in parenthesis pairing. There are 5 ('s and 3 )'s. I did a quick test, and from what I did, if you replace the double (( on either side of INDEX with a single ( …issue solved. Of course you'll want to verify the ranges.
And if I may make a recommendation? Get super familiar with how COLLECT works. It'll be your best friend. 😀 See this link for more information about the function:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Thanks Kerry. I seem to make these small mistakes often. Ugh. Much appreciated.
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
- 152 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!