VLOOKUP within IMPORTRANGE

google-sheets google-sheets-formula google-sheets-query gs-vlookup importrange
Luca picture Luca · Aug 31, 2016 · Viewed 27.7k times · Source

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

Luca picture Luca · Sep 3, 2016

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

Related questions

Google spreadsheet Query Error - column doesn't exist

Another problem with Google Spreadsheet API. I'm trying to use QUERY() function in order to get all customers from our database who are from Warsaw. Google API seems however to have a big problem with parsing my query. I've checked …

Read More
QUERY using cell contents as SQL variables

Here is what the spreadsheet I'm working with looks like: Summary table (top of sheet) Source data (same sheet, below output) I'm using the QUERY function to populate the appropriate feeds in the summary table with the data starting at …

Read More
Google Sheets: How do I filter view two columns OR instead of AND

In Google Sheets, I want to filter view my results so only rows with an "x" in column D AND/OR column E are shown. If I filter to show the columns with an "x" in them, it will only …

Read More