title: VLOOKUP within IMPORTRANGE
body: <p>I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a VLOOKUP:</p>
  
  <pre><code>=importrange("otherurl";cell("address";vlookup(value("201608"),"All_nodevice!$A$16:$C$1000",2,false)))
  </code></pre>
  
  <p>I get a general error.</p>
  
  <p>Does IMPORTRANGE support this kind of functionality?</p>
  
  <p>What I need to do is to extract data from the cell of another sheet that has the value 201608 on its left. Since IMORTRANGE wants a cell pointer such as $A$12, I thought to do these steps:</p>
  
  <ol>
  <li>search with a lookup the value.</li>
  <li>convert the result in a cell pointer.</li>
  </ol>