title: vba vlookup with a loop?
body: <p>I am working on Excel with a kind of city directory,</p>
  
  <p>I have a separated huge list of city ids. I would like to set a vlookup in order to get cities name from their ids...</p>
  
  <p>Example of my active sheet :</p>
  
  <pre><code> Id    Name
   1     NY
   2     LA 
  </code></pre>
  
  <p>Example of what I am looking for (I only have Id for the moment):</p>
  
  <pre><code> Id        New column
   34001     Beijing
   2078      Berlin
   3459      ...
   143
  </code></pre>
  
  <p>I achieved to copy/paste a single value, but I would clearly need some help to get multiple values with a loop.</p>
  
  <p>Any help will be appreciated, thanks</p>