Column function not working on select rows with Index Match

Claire LD Schulz

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!

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

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