Google Sheets QUERY Tips

posted in: Technology | 0

By no means is this considered a complete list. This is simply a list I am compiling as I run across issues and wanted to share if it helped anyone.


#REF Errors

Array result was not expanded because it would overwrite data in XX

This occurs when:

  1. You have data in the cell already and it doesn’t want to accidentally overwrite what you have. You can remove it to allow the query to return the results.
  2. Your query returns more than one record result. To see what or how many results are returned, move the query function to a clean and open area.

#N/A Errors

Query completed with an empty output.

Simply means your query returned no results.