title: Fill value based on another columns in Excel
body: <p>I have the following columns in excel, i want to change the ID column to New ID based on Match ID, for example on the ID column first data is Zrecruit_376840000000415007 which is Zrecruit_376840000000415007   =   5789 in Match ID and New ID column the ID should be replaced to 5789.</p>
  
  <pre><code>ID                              Match ID                         New ID
  Zrecruit_376840000000415007     Zrecruit_376840000000367020  =   5782
  Zrecruit_376840000000215296     Zrecruit_376840000000375036  =   5783
  Zrecruit_376840000000217195     Zrecruit_376840000000389001  =   5784
  Zrecruit_376840000000218111     Zrecruit_376840000000369168  =   5785
  Zrecruit_376840000000219665     Zrecruit_376840000000392001  =   5786
  Zrecruit_376840000000222030     Zrecruit_376840000000410013  =   5787
  Zrecruit_376840000000226008     Zrecruit_376840000000432013  =   5788
  Zrecruit_376840000000227079     Zrecruit_376840000000415007  =   5789
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/YvqR7.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YvqR7.jpg" alt="I have applied the formula as attached in the image but im getting N/A "></a></p>