VLOOKUP within IMPORTRANGE

Question

I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a VLOOKUP:

=importrange("otherurl";cell("address";vlookup(value("201608"),"All_nodevice!$A$16:$C$1000",2,false)))

I get a general error.

Does IMPORTRANGE support this kind of functionality?

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:

1. search with a lookup the value.
2. convert the result in a cell pointer.

Answer 1

I found the right way. May be it could be useful for someone else.

=VLOOKUP(201608;IMPORTRANGE("sheet url"; "All_nodevice!$A$16:$C$1000"); 2; 0)

or

=query(IMPORTRANGE("sheet url";"All_nodevice!$A$16:$C$1000");"select Col2 where Col1=201608 limit 1")