title: Vlookup partial number in Excel
body: <p>I'm trying to use a vlookup on telephone numbers by looking for the last 8 characters as some are begin 4401 and others just 1.</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>=IFERROR(VLOOKUP("*"&amp;(TRUNC(RIGHT(A3*1,8),0)*1),J:N,5,FALSE),"Unknown")
  </code></pre>
  
  <p>Column J contains the phone number and column N contains the source of the call (which is what I'm trying to extract).</p>
  
  <p>The problem I have is that the iferror 'Unknown' is being returned. If I change the numbers to words then it works, it seems that it's numbers that are the problem. Any ideas?</p>