How to return last match at specified indent level?

Elockwood

I have a master sheet of project tasks sorted by geographies. I'm looking for a formula that will return the Project Name (i.e. Project 1, Project 2, etc.) for each of the tasks under the Project. Since each "Project" is an indent level of 2, I've been trying to create a formula that would return the Project name by looking for the closest last level 2 at or above the search row. In effect, I want a vlookup that returns the first match from the rows above.

Any help on the best approach to this would be greatly appreciated! Thanks

Paul Newcome

Try this:

=IFERROR(INDEX(ANCESTORS([Project Task]@row), 2), "")

Paul Newcome

Try this:

=IFERROR(INDEX(ANCESTORS([Project Task]@row), 2), "")

Elockwood

Thanks Paul! That works.