Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- VLOOKUP Not Working on a PivotTable? Fixes That WorkYes, VLOOKUP can look up values in a PivotTable’s displayed cells, but it often fails when the pivot’s layout changes, the lookup…
- VLOOKUP Not Working? Fix Formulas Showing in ExcelIf Excel displays the VLOOKUP formula itself instead of a result, first turn off Formulas > Formula Auditing > Show Formulas; if…
- VLOOKUP Not Working Unless I Click the Cell?If VLOOKUP appears wrong until you click into its cell and press Enter, Excel is usually not recalculating the formula, or the…
- VLOOKUP Not Working? Check These Cell Format IssuesYes—VLOOKUP can fail when the lookup value and the value in the first column of its table are different underlying types, such…
- VLOOKUP Not Working in Excel? Show the Formula FixIf VLOOKUP appears in a cell instead of returning an answer, first turn off Formulas > Show Formulas in Excel for Microsoft…
- VLOOKUP Not Working Across Sheets? Fix the CausesYes—VLOOKUP works across worksheets in the same Excel workbook. Check that the formula points to the correct sheet and range, that the…
- VLOOKUP Not Working? Fix Common Excel Lookup ErrorsIf VLOOKUP is not working in Excel, first set its final argument to FALSE for an exact match, then check that the…
- VLOOKUP Not Working? Fix Excel Displaying the FormulaIf Excel displays =VLOOKUP(...) in a cell instead of a lookup result, first turn off Formulas > Formula Auditing > Show Formulas,…
- VLOOKUP Formula Not Working? Fix the Common ErrorsIf VLOOKUP is not working, first check that its lookup value is in the leftmost column of the selected range, that the…
- VLOOKUP Formula Not Working? Fix Show FormulaIf Excel displays =VLOOKUP(...) in a cell instead of a result, first turn off Show Formulas with Ctrl+` on Windows. If only…
- VLOOKUP Between Sheets Not Working? How to Fix ItIf VLOOKUP between sheets is not working, check that the lookup value is in the first column of the selected range, the…
- VLOOKUP Drag Down Not Working? Fix the FormulaIf VLOOKUP stops working or returns the wrong result when you drag it down, check that the table range is locked while…
- VLOOKUP Formula Correct but Not Working? Common FixesIf your VLOOKUP formula looks correct but is not working, first make it an exact match by setting its fourth argument to…
- VLOOKUP Column Index Number Not Working? How to Fix ItIf a VLOOKUP column index number is not working, check that it is a positive number no larger than the number of…
- VALUE Formula Not Working in Excel? Causes and FixesIf Excel’s VALUE formula is returning an error or leaving text unchanged, check whether the cell contains a number written in a…
- UPPER Formula in Excel Not Working? Fix the CauseIf Excel’s UPPER formula is not working, first check that the function is spelled correctly and the formula cell is not formatted…
- Excel UPPER Not Working? Fix the Common CausesIf UPPER is not working in Excel, enter =UPPER(A2) in a cell beside the text in A2, then press Enter; replace A2…
- Excel UNIQUE Formula Not Working? Fix Common CausesIf Excel’s UNIQUE formula is not working, check that you are using Microsoft 365 or Excel 2021 or later, that the formula…
- Excel Arrow Keys Not Working? Common Causes and FixesIf the arrow keys scroll the worksheet instead of moving the active cell, turn off Scroll Lock: press the ScrLk key on…
- Excel Arrow Keys Not Working? Fix Scroll Lock and MoreIf the arrow keys move the worksheet instead of the selected cell, turn off Scroll Lock; on many Windows keyboards, press ScrLk…
- Excel UNIQUE and FILTER Not Working? FixesIn Excel for Microsoft 365, put FILTER inside UNIQUE to return distinct values that meet a condition. With names in A2:A100 and…
- Excel UNIQUE Formula Not Working? Fix Common IssuesIf Excel’s UNIQUE formula is not working, first check that you have Microsoft 365 or Excel 2021 or later, that the formula…
- Unhide First Column in Excel Not Working? Try These FixesIf you cannot unhide the first column in Excel, select cell A1 through the Name Box, then choose Home > Format >…
- Transpose Not Working in Excel? Common Causes and FixesIf Transpose is not working in Excel, first check that you copied a cell range, then paste it into a clear destination…
- TRIM and CLEAN Not Working in Excel? Fix the Hidden SpacesTRIM and CLEAN can seem broken because they do not remove every character that looks like a space. If the text is…
- Transpose Formula in Excel Not Working? FixesIf your Excel TRANSPOSE formula is not working, first check whether its output cells are clear and whether your Excel version uses…
- Excel Formula Not Working Today? Fix Common CausesIf the Excel TODAY formula is not working, enter =TODAY() in a cell, set the cell to a date format, and make…
- Excel Text to Columns Not Working? Fix Common CausesIf Text to Columns is splitting data incorrectly—or not splitting it at all—select the source cells, go to Data > Text to…
- SUMPRODUCT Formula Not Working? Fix the Common CausesIf SUMPRODUCT is not working in Excel, first check that every range in the formula has the same dimensions, then check the…
- SUMIFS Excel Formula Not Working? Fix the CauseIf SUMIFS is not working, first check its argument order, matching range sizes, and criteria: Excel expects =SUMIFS(sum_range,criteria_range1,criteria1,...), and every criteria range…