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
