title: VLook-Up Match first 3 characters of one column with another column
body: <p>I'm trying to match a list of words from Column A against another list of words in column B.  I only need the first three characters of the words in column A to match the first three characters of the words in column B. I would like the result to be the same value in column B. Is this possible?  </p>
  
  <p>Here is what I'm using: <code>=VLOOKUP(LEFT(A1,3),B$2:B$22, 2,TRUE)</code></p>
  
  <p>But, I keep getting #N/A. Can anyone help?</p>