Query ignoring text

Question

When I share data with sub-subcontractors, I use the QUERY function to return a subset based on a company name match. I never had any issues in the past, but lately QUERY has not been returning values if they are text, only if they are numbers.

Also, Sheets' "Fill Down" shortcut ⌘+D has stopped working (MacBook Air).

Did I mess something up, or did something change?

Example QUERY:

=QUERY(
   IMPORTRANGE(spreadsheet_url, range_string),
   "select Col2, Col3, Col4, Col5, Col6, Col7,
      Col8, Col13, Col14, Col15 where Col5
      matches 'company_name'")

Answer 1

query have been ignoring data that includes text and not numbers

The query() function only accepts one data type per column. If you have a mix of text strings like abc and numbers like 123 in a column, one or the other type will be returned as nulls.

To get all data from columns that have mixed types, use filter(), like this:

=let( 
  data, importrange("DOCUMENT", "TAB!A:DK"), 
  filtered, filter(data, search("Company name", choosecols(data, 5))), 
  choosecols(filtered, 2, 3, 4, 5, 6, 7, 8, 13, 14, 15) 
)