Suppress #N/A returned by Google Sheets vlookup
<p>I have a Google Sheet (<a href="https://docs.google.com/spreadsheets/d/1rEXibEn_LbaezSrjYutBZtZNzINGbQool0-HPLWzKy4/edit?usp=sharing" rel="noreferrer">example</a>) with a basic vlookup to create a summable column. It returns "#N/A" for every search key not found, and attaches the following error to those cells:</p>

<blockquote>
  <p>Error Did not find value 'me@me.com' in VLOOKUP evaluation.</p>
</blockquote>

<p>After much searching the only solution I found was to wrap the vlookup in an IF(ISNA()), given in <a href="https://stackoverflow.com/a/28794279">How to link various Google spreadsheets using IMPORTRANGEs that contain VLOOKUP formulas without getting #N/A returned?</a>. This works, but it really seems like I should not have to do this. Is there another way?</p>