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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!