title: How to use VLOOK to find text value in column 2 and return the text value in column one, which is right next to the found value
body: <p>In table A, I tried to use <code>=VLOOKUP(A2,VS!$A1:$B99,1,FALSE)</code> to see if there is a match in table VS. If there is a match I want to return the text value which is in the column next to the match value. But all the returned results are #N/A. </p>
  
  <p>I'm not sure if I explain my question clearly. If not, please let me know and I will update my question.</p>