title: #NA error in vlooup with another workbook
body: <p>I want to retrieve the value of column 2 in x workbook on the basis of 20700 so if I directly give lookup value, formula is working fine but if I replace my lookup value with the range like A2[having the 20700 in A column] so It gives me N/A error. </p>
  
  <p>VLOOKUP(20700,'[X.xlsx]Sheet1'!$A:$B,2,0)- working fine
  VLOOKUP(K2,'[X.xlsx]Sheet1'!$A:$B,2,0) - gives error</p>
  
  <p>Kindly suggest me what to do. Thanks in advance.</p>