title: Why does Vlookup not working with another workbook?
body: <p>I am trying to use Vlookup from another sheet </p>
  
  <p>=VLOOKUP(C11,[C1]Sheet1!A1:C3,3) gives me random Values.</p>
  
  <p>where[C1] contains a path to another workbook
  and C11 contains the value to be looked up.
  However, when I use a sheet in the same workbook and use the above formula it works properly.</p>
  
  <p>=VLOOKUP(C11,Sheet2!A1:C3,3)</p>
  
  <p>The data in the cells is as follows:
  ColA    ColB     ColC
  A blank    1
  B blank    2
  C blank    3</p>