title: Excel VBA Xlookup concerns
body: <p>Need help with this formula:</p>
  <pre><code>ws6.Range(&quot;AA2:AA&quot; &amp; lrowWFS).Formula = &quot;=IFERROR(XLOOKUP(W2,'New Stock Data'!I:I,'New Stock Data'!D:D),&quot;&quot;)&quot;
  </code></pre>
  <p>It returns to blank :(</p>