Errors

What Google Sheets formula errors mean and how to fix them: parse errors, #REF!, #VALUE!, #N/A, INDEX MATCH and IMPORTRANGE problems, each one reproduced.