New answers tagged

1

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=<&...


0

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:...


Top 50 recent answers are included