CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulagoogle-sheets-querygs-vlookupimportrange
Luca
Luca

Reputation: 984

VLOOKUP within IMPORTRANGE

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.

Upvotes: 6

Views: 36616

Answers (2)

user10209379
user10209379

Reputation: 41

Just the ID worked for me as well instead of the URL. I had my numbers as text, so kept getting an error at first. Silly mistake, but what you are looking up probably has to be the same kind of thing (text vs numbers).

=vlookup(Q6,IMPORTRANGE("1m9IN4_NH717VATXWLnPgTvrKxnRHwtH8z-f38r9F3zY","Props!A1:Bb400"),38,false)

Upvotes: 4

Luca
Luca

Reputation: 984

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")

Upvotes: 14

Related Questions