#NAME?Supported on: Microsoft Excel® & Google Sheets™

How to Fix the #NAME? Error in Excel & Google Sheets

The #NAME? error occurs when Excel or Google Sheets cannot recognize text within a formula, typically due to misspelled function names, missing quotation marks around strings, or invalid named ranges.

Common Root Causes of #NAME?

  • 1Typo in the function name (e.g., =VLOOKP() instead of =VLOOKUP() or =SUMIFS() misspelled).
  • 2Omitting quotation marks around text arguments (e.g., =IF(A1=Pending, 1, 0) instead of =IF(A1="Pending", 1, 0)).
  • 3Referencing a Named Range or Global Variable that has not been defined in the workbook.
  • 4Colon omitted in a range reference (e.g., =SUM(A1 A10) instead of =SUM(A1:A10)).

Formula Syntax Comparison

Broken Formula
=IF(B2=Active, XLOOKP(A2, D2:D50, E2:E50), 0)
Corrected Formula
=IF(B2="Active", XLOOKUP(A2, D2:D50, E2:E50), 0)

Manual Step-by-Step Fix

1

Step 1

Verify spelling of all function names against official Excel/Sheets function documentation.

2

Step 2

Enclose all text string values in double quotation marks (").

3

Step 3

Check Name Manager in Excel or Named Ranges in Google Sheets to confirm variable definitions.

Automate this Fix with SheetFactorys

Zero manual debugging required

SheetFactorys leverages its built-in formula lexer and global variables engine to automatically correct misspelled syntax, insert missing quotes, and sync undefined Named Ranges across the active workbook.

Available in Microsoft AppSource & Google Workspace
Install for Excel®Install for Sheets™