Diagnose & Fix
Start from the error you can see, understand the likely cause, and fix the data or logic instead of hiding the symptom.
Excel #N/A Error
A lookup could not find the requested match.
Open →ERROR HELPXLOOKUP Not Working
An XLOOKUP returns #N/A, wrong values or fails to spill.
Open →ERROR HELPVLOOKUP Returns Wrong Value
Approximate match or an unstable column index can return unexpected data.
Open →ERROR HELPExcel Number Stored as Text
Numeric-looking cells do not sum, sort or compare correctly.
Open →ERROR HELPExcel Date Not Recognized
Imported dates remain text or swap day and month.
Open →ERROR HELPExcel Formula Shows as Text
A cell displays =SUM(...) instead of a result.
Open →ERROR HELPExcel #SPILL! Error
A dynamic array cannot place all of its results.
Open →ERROR HELPExcel #REF! Error
A formula points to a reference that no longer exists.
Open →ERROR HELPExcel Circular Reference
A formula depends on itself directly or indirectly.
Open →ERROR HELPSQL Invalid Column Name
The query references a field the database cannot resolve.
Open →ERROR HELPSQL Ambiguous Column
Two joined tables expose the same column name.
Open →ERROR HELPSQL Duplicate Rows After JOIN
A join key matches several rows on one or both sides.
Open →ERROR HELPSQL NULL Comparison Returns No Rows
Equality operators do not treat NULL like a normal value.
Open →ERROR HELPSQL Conversion Error
Text and numeric/date types are being converted incompatibly.
Open →ERROR HELPSQL GROUP BY Error
A selected field is neither grouped nor aggregated.
Open →ERROR HELPSQL LIKE Query Is Slow
A leading wildcard can prevent efficient index seeking.
Open →ERROR HELPSQL Query Timeout
The query exceeds an execution or application timeout.
Open →ERROR HELPCSV Opens in One Column
The file delimiter does not match the program’s expected separator.
Open →ERROR HELPCSV Leading Zeros Disappear
Spreadsheet software interprets an identifier as a number.
Open →ERROR HELPCSV Special Characters Broken
The file was decoded with the wrong text encoding.
Open →ERROR HELPCSV Extra Rows or Shifted Columns
Unescaped delimiters or malformed quotes break row structure.
Open →ERROR HELPHTML Form Button Does Nothing
A button type, form association or JavaScript handler may not match the intended behavior.
Open →ERROR HELPHTML Label Does Not Focus Input
The label for attribute does not match the input id.
Open →ERROR HELPHTML Page Overflows on Mobile
A fixed width, long code block or table exceeds the viewport.
Open →