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.
Troubleshooting
#REF Errors
Array result was not expanded because it would overwrite data in XX
This occurs when:
- 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.
- 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.