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!

Find more posts tagged with

Accepted answers

Leibel S

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))

All comments

Leibel S

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))

Claire LD Schulz

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!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.