title: Excel vba: check if VLookup returns empty value, given that Vlookup substitutes empty with zero
body: <p>So I have a table for different regions and corresponding values for different years 2014-2017. Not all regions have value for the year 2017. However, if I make a <code>WorksheetFunction.VLookup(...)</code> it will return 0 if the cell in question is empty. </p>
  
  <p>I need to put my special value (-1) instead of 0 if the cell for a given region is empty, however, I can't differentiate between real zeroes and zeroes <code>Vlookup</code> returns instead of empty values. How would I do it?</p>
  
  <p><strong>EDIT</strong>: I can't use <code>IsEmpty</code> on individual cells, because I <strong>don't know</strong> the result's cell's address - I loop though them in a cycle without even knowing a first argument's address. All I have is the result - either a real or a fake zero.</p>