19 мая 2023 г. · I want to query data from another sheet by checking if the data_range's column C (invoice#) matches any one of multiple lookup values from a range in the ...

8 янв. 2022 г. · Sheet1 contains another sheet that is imported with the formula import range. The first column contains the first names, the second row is the date, and the ...

29 мар. 2013 г. · You could use COUNTIF. For example: =COUNTIF(G:G,6) > 0. if you want to find the number 6 in the range G:G, and/or =COUNTIF(A1:B7,"d") > 0.

26 мар. 2021 г. · I need to get specific column values for rows where any column in a range matches a value. I can do it with FILTER using OR (+) condition for every column.

6 июл. 2018 г. · I try to figure out how to get a value based on "if some word is in a range". So formulas from (Google Sheets formula for "if contains") works.

28 нояб. 2023 г. · I am trying to write a QUERY function that will return the records that match the "filters" in range A2:D3.

6 дек. 2013 г. · I want to import a range of data from one Google Spreadsheet (1) into another (2), but only when Column J in spreadsheet 1 contains a 'yes'.

22 февр. 2021 г. · All I want is to fill column B with TRUE if the cell in column A contains one or more of the strings in the range C2:C13.

14 янв. 2016 г. · I'm trying to figure out if I can pull data from a sheet in a Google Sheets Workbook based on an alpha range.

5 нояб. 2015 г. · I'm trying to query a range of names in Google Spreadsheets. When I try and make a query like: =QUERY('QA Import'!A1:H, "select A where G = "&B2&"")