Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Not Dragging Down Numbers? Fix the Fill HandleIf Excel repeats a number instead of counting up, select the first two numbers in the pattern and drag the fill handle…
- XLOOKUP Excel Not Working? Fix Common Errors and CausesIf XLOOKUP is not working, first check that your Excel version supports it, then confirm the lookup and return ranges line up…
- VLOOKUP in Excel: Find Matching Values and Fix ErrorsTo find a matching value in Excel, use VLOOKUP with an exact-match setting. For example, if IDs are in A2:A6, department names…
- Excel Not Copying and Pasting Correctly? Fix ItIf Excel is not copying and pasting correctly, first press Esc, select the source cells again, press Ctrl+C, click one destination cell,…
- TEXTJOIN in Excel Not Working? Common FixesIf TEXTJOIN in Excel is not working, first check that the function is spelled TEXTJOIN, your Excel version supports it, and your…
- Excel Not Converting to Number? Fix Text-Formatted ValuesIf Excel is not converting a value to a number, first select the affected cells and use the warning icon that appears…
- Excel Not Auto Filling Text? Fix the Common CausesIf Excel is not auto-filling text, check the feature you mean: turn on AutoComplete for suggestions based on entries already in a…
- Excel Not a Number? Understand #NUM! and ISNUMBERIn Excel, “not a number” can refer to the #NUM! error, which means a formula cannot produce a valid numeric result, or…
- Excel Not Allowing Copy and Paste? How to Fix ItIf Excel is not allowing copy and paste, press Esc, select a normal cell, and try Ctrl+C followed by Ctrl+V; if it…
- Excel IFS Error? Common Causes and FixesWith a score in A2, an IFS formula needs a final fallback if every test might be false: =IFS(A2>=90,"A",A2>=80,"B",TRUE,"F"). If Excel shows…
- Excel Not Working? Fixes for Common ProblemsIf Excel is not working, first save a copy of your workbook if you can, close and reopen Excel, and check whether…
- XLOOKUP Excel IF ERROR: Fix Missing Matches and ErrorsTo show a friendly result when XLOOKUP cannot find a match, use its fourth argument: with lookup value in D2, codes in…
- Excel Freezing? Fix a Workbook That Stops RespondingIf Excel is freezing, first wait briefly to see whether it is finishing a calculation or loading a large workbook; then save…
- Excel AVERAGEIF #DIV/0! Error: Causes, Checks, and FixesExcel’s AVERAGEIF returns #DIV/0! when it has no numeric values to average among the cells that meet the criterion. Check whether any…
- IFERROR in Excel Not Working? Causes and Practical FixesIf IFERROR is not working in Excel, first check that the cell contains a formula that actually returns an Excel error, and…
- COUNTIFS Excel Error? How to Find and Fix Common CausesA COUNTIFS error is usually caused by criteria ranges with different dimensions, invalid criteria syntax, or references that no longer work. First…
- SUMIFS Excel: Common Errors and How to Fix ThemSUMIFS errors usually come from a misplaced argument, ranges that do not match, or criteria that do not match the data exactly.…
- SUMIFS Excel Error? Causes, Checks, and Practical FixesA SUMIFS error in Excel usually comes from a misspelled function or reference, criteria written in the wrong form, or ranges that…
- Excel HLOOKUP Not Working? Fix Lookup and Match Errors NowIf HLOOKUP is not working, first check that the value you want to find is in the first row of the lookup…
- VLOOKUP #N/A Error: Why It Happens and How to Fix ItExcel returns #N/A from VLOOKUP when it cannot find a matching value under the formula’s search rules. Start by checking that the…
- VLOOKUP Excel Not Working? Fix the Most Common ErrorsIf VLOOKUP in Excel is not working, first set its fourth argument to FALSE for an exact match, then check that the…
- How to Fix Spill Error in ExcelFix #SPILL! in Excel by finding blocked cells, merged ranges, table limits, or oversized results. Follow these practical steps to restore your…