Formula to populate column with value from another column

Laurenzella

Hello, I have a helper column (Project Title) that is supposed to populate with the Project Name based on the below formula. The AI indicates that the formula is supposed to locate the cell in the column "Action Items" that contains the term "Project Name" and then populates the "Project Title" column with whatever is contained in the "Notes" column in the same row. This is the desired behavior, but as of right now, nothing is populating in the Project Title column. Any ideas on how to tweak the formula? See screenshot below.

Formula is =INDEX(Notes:Notes, MATCH("Project Name", [Action Items]:[Action Items]))

Paul Newcome

Try specifying an exact match on "Project Name".

=INDEX(Notes:Notes, MATCH("Project Name", [Action Items]:[Action Items], 0))

.

KPH

The formula looks fine. Could it be that you have a row above this one that also has "Project Name" in the Action Items column, but nothing in the Notes column? The formula will return the value in Notes from the first row that it finds with "Project Name".

Laurenzella

There is no other row with that label, but I am thinking it is not working because the Notes cell is linked in from another sheet perhaps?

Paul Newcome

Try specifying an exact match on "Project Name".

=INDEX(Notes:Notes, MATCH("Project Name", [Action Items]:[Action Items], 0))

.

Laurenzella

Thank you, that did work! In the interim, I was also able to figure out a workaround with a cross-sheet reference to the same data.

Paul Newcome

Happy to help. 👍️