title: Excel - Replace cell value based on a value in another column
body: <p>I am wondering if there is a way to replace a cell value from another list without having to write a VB script.</p>
  
  <p>Here is the problem I am trying to resolve:</p>
  
  <p>I have last names in a column:</p>
  
  <p>Smith<br>
  Jones<br>
  Taylor<br>
  etc.</p>
  
  <p>I have another column with IDs e.g. </p>
  
  <p>Smith_ID<br>
  Taylor_B<br>
  Jones_C</p>
  
  <p>I would like to replace <code>Smith</code> with <code>Smith_ID</code>, <code>Jones</code> with <code>Jones_C</code> etc. Obviously my list is much longer than 3 entries.</p>