Setting a range using a hierarchy
Hi, I've got an INDEX function that looks up values in a group of rows under a parent in the same sheet.
=INDEX(ID$3:$Goal$183, MATCH(ID214, $ID$3:$ID$183, 0), 5)
Instead of having $183 I'd like to use a function to set the range to everything under the parent (in row 3), no matter how deep it is. Is there a way to do this?
Help Article Resources
Check out the Formula Handbook template!