Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Which One Is Not an Aggregate Function? SQL GuideA scalar function such as UPPER() is not an aggregate function: it transforms a value in an individual row, while an aggregate…
- Jupyter Notebook: How to Split a Cell and Fix Common IssuesTo split a Jupyter Notebook cell, click inside it where you want the break, then choose Edit > Split Cell. In many…
- Data Table Input Cell Reference Is Not Valid in ExcelIn Excel, “Data table input cell reference is not valid” usually means the Row input cell or Column input cell in the…
- Print Area in Excel: Set, Change, and Fix ItA print area in Excel is a selected range of cells that Excel prints, leaving cells outside that range out of the…
- COUNTIFS Not Counting Correctly? Fix the CriteriaIf COUNTIFS is returning zero or the wrong total in Excel, first check that every criteria range has the same size and…
- Excel Shortcut Not Working? Find and Fix the CauseIf an Excel shortcut is not working, first check that Excel has focus, that you are pressing the correct keys for your…
- XLOOKUP Not Working With Text? Fix the MatchYes—XLOOKUP can look up text, and it uses an exact match by default. When it fails, the usual cause is that the…
- XLOOKUP Not Working With Numbers? Fix the MatchIf XLOOKUP is not finding a number, first check whether the lookup value and lookup column contain the same kind of data:…
- XLOOKUP Not Working? Check These Format IssuesYes—differences in the underlying data type or characters can make XLOOKUP return no match, even when two cells look identical. Cell formatting…
- XLOOKUP Not Working in Excel 2019? Fixes and OptionsXLOOKUP is not included in Excel 2019, so updating that version or changing the formula will not make the function available. To…
- XLOOKUP Not Working in Excel 2016? The Real ReasonNo—Excel 2016 does not include XLOOKUP, so the function will not work there even if the formula is typed correctly. Use VLOOKUP…
- XLOOKUP Not Working? Common Causes, Checks, and FixesIf XLOOKUP is not working, first check that your Excel version supports it, then verify the lookup value and lookup range match…
- XLOOKUP Not Working Across Workbooks? Fix the LinksYes—XLOOKUP can look up a value in another Excel workbook. For the most reliable results, open both workbooks, check that the external…
- XLOOKUP If Not Found Not Working? How to Fix ItIf XLOOKUP is not showing your “not found” message, first check that the message is supplied as the formula’s fourth argument, if_not_found.…
- XLOOKUP Exact Match Not Working? Fix Common CausesXLOOKUP uses exact matching by default, so a failed result usually means the lookup value and the values in the lookup range…
- XLOOKUP and VLOOKUP Not Working? Fix Common ErrorsIf XLOOKUP or VLOOKUP is not working, first check that the lookup value and lookup column contain the same kind of data,…
- WORKDAY Formula Not Working? Fix Excel Date ErrorsIf Excel’s WORKDAY formula is returning an error or an unexpected date, check that the start date is a real Excel date,…
- Excel Wrap Text Not Working? Fix the Common CausesIf Wrap Text appears not to work in Excel, select the affected cells and choose Home > Alignment > Wrap Text, then…
- Why Is VLOOKUP Not Working in Excel?VLOOKUP usually fails because its lookup range, match setting, or data types do not match the data you are searching. Check that…
- Why Is VLOOKUP Not Working? Common Excel Problems & FixesVLOOKUP usually fails because its match setting is wrong, the lookup value does not exactly match the first column of the search…
- Why Is the Hyperlink Not Working in Microsoft Word?A hyperlink in Word usually will not open because Word requires Ctrl+click on Windows, the link is only plain text, or its…
- Why VLOOKUP Is Not Working When the Value ExistsVLOOKUP can fail even when a value appears in the table because Excel may be comparing different underlying values, searching the wrong…
- SUMIFS Not Working? Fix Common Excel ErrorsSUMIFS usually fails because its sum range and criteria ranges do not line up, a criterion does not match the data exactly,…
- Why Is INDEX MATCH Not Working? Common Excel FixesINDEX MATCH usually fails because MATCH is using the wrong match type, the lookup and return ranges do not line up, or…
- Why Is IFERROR Not Working in Excel?IFERROR works only when the expression inside it returns an Excel error; it will not replace ordinary text, blanks, or unexpected-but-valid results.…
- Why Is My VLOOKUP Not Working? Common FixesVLOOKUP usually fails because its last argument is missing or set to approximate match, the lookup value does not exactly match the…
- Why Is Excel COUNTIF Not Working? Common FixesExcel COUNTIF usually fails because its criteria do not match the cells as stored, the range points to the wrong data, or…
- Excel Spill Error: Why It Happens and How to Fix ItExcel shows a #SPILL! error when a formula returns multiple results but Excel cannot place those results in the cells around the…
- Why Is a Hyperlink Not Working in Outlook?A hyperlink may not work in Outlook because the link address is invalid, Windows has no working default browser for web links,…
- Why COUNTIFS Is Not Working Properly in ExcelCOUNTIFS usually gives an unexpected result because a criterion does not match the cell values as Excel stores them, the criteria are…