title: Applying VLOOKUP function with IF statement to a range
body: <p>I'm trying to write a VBA code that would be the equivalent of this excel function for a definite range of cells. </p>
  
  <pre><code>=if(A1="", "", vlookup(A1, K1:M2000, 3, false))
  </code></pre>
  
  <p>I want to apply this for range(A1:A15) and insert the function in range (B1:B15) using VBA.</p>