INDEX / MATCH Formula Question
Hello,
I am missing something with executing this formula. This is my first time trying to apply to my sheet. I can only successfully return a #Unparseable error. 😥 Would appreciate any guidance you can provide.
Formula: =INDEX({CI Weight}), MATCH([Task Name]@row, {Project Name}, 0)
Goal: Pull in ranking (CI Weight) from source sheet
Thanks so much in advance!! 🤩
Best Answers
-
Remove the ) after CI WEIGHT
-
My hero!! Muchas gracias, @Michael Culley ! 🤩🤩
-
If you want it to only apply to parent rows then it would look more like this:
=IF(COUNT(CHILDREN([Task Name]@row)) <> 0, INDEX({CI Weight}, MATCH([Task Name]@row, {Project Name}, 0)))
Answers
-
Missing 1 parenthesis at the end.
-
Thanks for your help @Michael Culley. I still get the same outcome, #Unparseable.
-
Remove the ) after CI WEIGHT
-
My hero!! Muchas gracias, @Michael Culley ! 🤩🤩
-
@Michael Culley , using this formula can I add a parent function to it? I would like to apply as a column formula and realizing that there are cells that I don't need this to apply to? When I use =PARENT(INDEX({CI Weight}, MATCH([Task Name]@row, {Project Name}, 0))), there's a syntax error.
-
If you want it to only apply to parent rows then it would look more like this:
=IF(COUNT(CHILDREN([Task Name]@row)) <> 0, INDEX({CI Weight}, MATCH([Task Name]@row, {Project Name}, 0)))
-
Awesome! Thank you @Paul Newcome !! I ended up solving using Ancestor in my formula since the grandchildren were also returning a result, but I like learning this new format as well. 🤩
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!