Spreadsheet Error Troubleshooter

Help me fix this spreadsheet error:

**Error Details:**
- Error message: [e.g., #REF!, #VALUE!, #N/A, #NAME?, #NUM!, #DIV/0!, Circular reference]
- Cell location: [e.g., D5]
- When it started: [after what action]

**Formula Causing Error:**
```
[Paste the exact formula]
```

**Context:**
- What the formula should do: [describe expected result]
- Recent changes made: [any edits to sheet, data, or structure]
- Works in other cells: [Yes/No]

**Data References:**
- Source data location: [describe where formula pulls from]
- Any external references: [other sheets/workbooks]
- Sample of source data: [paste if relevant]

**Already Tried:**
- [List any troubleshooting steps attempted]

**Environment:**
- Application: [Excel version / Google Sheets]
- File type: [.xlsx, .xlsm, .csv, etc.]
- Shared workbook: [Yes/No]

Please provide:
1. Diagnosis of the error cause
2. Step-by-step fix
3. Explanation of why this error occurs
4. Prevention tips for the future
5. Formula best practices to avoid similar issues