Return value in Parent Cell for Child value

rstrecker

I have been trying to use the Index & Match function to automatically populate in the Parent row based on the status of a Child row, however, the formula will not pick up the Child status.

For example, I want the STATUS column of the Parent row to populate with the STATUS of the Child where the Child DOCUMENT TYPE = "Trust Agreement".  I've tried a few different formulas, but none of them are picking up the correct Child Status for the Trust Agreement value.  

Any help with the formula would be greatly appreciated.

Paul Newcome

Try adjusting your ranges.

 

=INDEX(CHILDREN(), MATCH("Trust Agreement", CHILDREN([DOCUMENT TYPE]@row), 0))

rstrecker

Thanks so much, works perfectly!

Paul Newcome

Happy to help!