Custom Column Creation help

Hi, Can any one please help me to derive below Type Flag as column from Main Num and Alternate Number based on below logic.   if Main Num not present in Alternate Number list then it's parent if ...