VLOOKUP within IMPORTRANGE
<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>