I have multiple columns covering two data types: Parent and Child.
I am looking to match multiple child data to one parent, for example:
If the child type has the same type name (column F highlighted in yellow) and these also have the same status (column H highlighted in yellow) THAT ALSO matches the status for the parent (column H highlighted in orange) then the child would be assigned to that single parent.
Basically, if column f has the same type relating to the "child" in column B that also has the same status in column h which also matches the same parent status then the 4 child types would be assigned to the one parent
I have tried a few IF but not getting very far
Hope someone can help