title: Excel vlookup right 5 character from array
body: <p>I would like to search the right 5 characters of array $A:$B for the value in column C and return a concatenated value of column A, "." and column B.</p>
  
  <pre><code>00010025     0     10025     00010025.0
  00010026     0     10026     00010026.0
  00010027     0     10027     00010027.0
  00010029     0     10028     NoMatch
  00010055     1     10054     NoMatch
  00010101     1     10101     00010101.1
  00010102     1     10102     00010102.1
  </code></pre>
  
  <p>This works if the value in ColumnC has the leading zeros.  However, the "raw" data is only 5 characters.</p>
  
  <pre><code>=IF(ISERROR(VLOOKUP($D12,$A:$B,2,FALSE)),0,CONCATENATE($D12,".",VLOOKUP($D12,$A:$B,2,FALSE)))
  </code></pre>