title: How to unite value in a column using lookup function
body: <p>I have an example with two columns (Name, Region), column (Segment) is the result I have solved.</p>
  
  <p><a href="https://i.stack.imgur.com/iYWWt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iYWWt.png" alt="enter image description here"></a></p>
  
  <p>The condition for column "Segment" is IF(AND(John = "North", John ="South", "John"=Centre"), "N-S", IF(OR(AND(John = "North", "John"=Centre"), John="North"), "N", IF(John="South", "S")))<br/>
  I can't find any way to solve this problem.<br/>
  I hope anyone can help me. Thanks!</p>