Column function not working on select rows with Index Match
Hello Community,
I am at a loss on this issue. I have two sheets; I use one (Reporting Sheet) for external resources to report status into via reports, and the second (Master List) I use to house lots of data about projects and pull-in the reporting data. I have column formulas to pull information from the Reporting Sheet into the Master list using the project ID to link. All my rows/formulas were functioning, and then I updated a project ID, and the rows I changed are now no longer pulling as expected (they are pulling from a different ID altogether - but all the other rows I didn't touch seem to be fine).
Here is an example of my formula in the Master List:
=INDEX({Schedule Health - Reporting Sheet}, MATCH([Project ID]@row, {Project ID - Reporting Sheet}))
Ideas???
Thanks!
Best Answer
-
Do you have a lot of rows?
Try adding to the MATCH function as shown below:
=INDEX({Schedule Health - Reporting Sheet}, MATCH([Project ID]@row, {Project ID - Reporting Sheet},0))
Answers
-
Do you have a lot of rows?
Try adding to the MATCH function as shown below:
=INDEX({Schedule Health - Reporting Sheet}, MATCH([Project ID]@row, {Project ID - Reporting Sheet},0))
-
Yes! I also was looking at this post (https://community.smartsheet.com/discussion/75715/index-match-returning-the-wrong-value) and think that is the same fix - I was missing the ",0" critical.
Thank you!!
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!