INDEX MATCH Formula with row Hierarchy
I need to reference information from the Digital column and Match it into the Digital Row. The row in white is the Parent column and the rows in grey are the Children. Here is the formula I'm using:
=(INDEX(PARENT(Digital@row), MATCH("Digital", CHILDREN(WO@row), 0)))
In the Parent row the cell is blank, but in the Children row it says #NO MATCH. I know I have to be close I'm just not sure what to try next.
Help Article Resources
Check out the Formula Handbook template!