How to use INDEX(MATCH()) when I have multiple children/parent relationship?

Marcelo Scherman

Basically I'm trying to use index(match()) formula as a way to grab data from one template and use in another.

They are very similar but one does not have the row information required, since it is in a parent/children relation. Example:

Project Name

Project Phase

To use the formula, I would need to use the relation as: Project Name+Project Phase (as if it was Concatenate).

It would result in something like this:

=INDEX({Tech Deliverables - Collect Intervalo 1}; MATCH([Project - Wave]59; {Tech Deliverables - Collect Intervalo 2}; 0))

Any help? If more detail if required, I'll be happy to provide at some point.

Regards,

Marcelo

Paul Newcome

Are you able to provide screenshots for reference?