title: Excel - Replace values in one column by values in another column
body: <p>I have a lot fo data in Excel spreadsheet. One of the column keeps the ISO code of the country. I would like to replace this value with the whole name of the country. Of course there are lists of ISO codes and corresponding country names on the internet, but I would like to know, if there's a better way than Ctrl+H thousand times for each ISO code value.</p>
  
  <p>Thank you in advance.</p>
  
  <p>Example: (I would like to replace values in A by these in E based on value from D)</p>
  
  <p><a href="https://i.stack.imgur.com/qI6Bx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qI6Bx.png" alt="Example"></a></p>