Possible IF Statement?

Occasional Visitor



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 helpIF Statment.JPG

0 Replies