title: Merge two Excel tables Based on matching data in Columns
body: <p>I've been working on a excel problem, that I need to find an answer for I'll explain it below.</p>
  
  <p>I've Table01 with the Columns :</p>
  
  <ul>
  <li>Group No</li>
  <li>Name</li>
  <li>Price</li>
  </ul>
  
  <p>I've Table02 with the columns:</p>
  
  <ul>
  <li>Group No</li>
  <li>City</li>
  <li>Code</li>
  </ul>
  
  <p>I've merged two tables of Table01 &amp; Table02 as shown in the Image03 , But without order. </p>
  
  <p><strong>But,as you see Group No Column is similar in both tables.</strong></p>
  
  <p>What I need is to get the matching rows of Table01 &amp; 02 considering 'Group No' Column.</p>
  
  <p>The Final result is to be seen as the final image.</p>
  
  <p>Is there a way to do this with excel functions ?</p>
  
  <p><img src="https://i.stack.imgur.com/QAhrv.jpg" alt="The Image"></p>
  
  <p>Thank You!</p>