Tag Info

New answers tagged importrange

importrange & query

Regarding =QUERY(IMPORTRANGE("SheetA","F!O:P"), “Select #(Col2) where Y N(Col1) contains ‘Y’ “) one problem is that it's using typographical quotes instead of straight quotes. As second problem is that the second argument syntax is wrong. Regarding =QUERY(IMPORTRANGE("SheetA","F!O:P"), "Select * Where Col2=<&...

answered Nov 28 at 17:18

Rubén♦

36.2k11 gold badges68 silver badges228 bronze badges

Attempting to use a LOOKUP with an Importrange tab on Google Sheets to make sure values across two sheets are correct, but I keep getting errors

The formula 'Sectors and subsectors'!F56 is =vlookup(B56,'Sector list'!A$2:A$40,2,FALSE) The error ocurrs b/c the third parameter is 2 but the second parameter only has one column. The formula 'Sectors and subsectors'!F57 is =lookup(B57,'Sector list'!A$2:A$40,'Sector list'!B:B) The value in B57 is Five. The error ocurrs b/c the values in 'Sector list'!A$2:...

google-sheets formulas importrange

answered Nov 11 at 17:13

Rubén♦

36.2k11 gold badges68 silver badges228 bronze badges

Stack Exchange Network

current community

your communities

more stack exchange communities

Tag Info

New answers tagged importrange

importrange & query

Attempting to use a LOOKUP with an Importrange tab on Google Sheets to make sure values across two sheets are correct, but I keep getting errors

Tag Info

New answers tagged importrange

importrange & query

Attempting to use a LOOKUP with an Importrange tab on Google Sheets to make sure values across two sheets are correct, but I keep getting errors

Related Tags