How can I capture the value in a parent row to match the value in one child row?
I have a matrix by job title that each child row enters one value. So there are 4 child rows, but only one value in each of the 4 columns. I want the parent row to reflect the value when not blank of the child row beneath it. Is that used with a MATCH formula? How can it reflect "if not blank" and take that value, whatever it is? Names may be reassigned so I want the parent to change along with it.
Help Article Resources
Check out the Formula Handbook template!