Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Spill Error: Why It Keeps Happening and How to Fix ItYou keep getting a spill error in Excel when a formula is trying to return multiple results but Excel cannot place them…
- Excel #VALUE! Error: Why It Happens and How to Fix ItYou keep getting a #VALUE! error in Excel because a formula is receiving a value or argument it cannot use in that…
- Why Are My SUMIFS Not Working? Excel FixesWhen SUMIFS is not working in Excel, the most common causes are mismatched range sizes, criteria that do not match the underlying…
- Why Am I Getting a #REF! Error in Excel?You are getting a #REF! error because an Excel formula contains a reference that is no longer valid, or because the formula…
- Why Are My COUNTIFS Not Working? Fix the Common CausesCOUNTIFS usually fails because a criterion does not match the cell values exactly, its ranges are misaligned, or the formula’s references point…
- Excel #NAME? Error: Causes and FixesYou are getting Excel’s #NAME? error because Excel cannot recognize some text in a formula as a valid function, defined name, or…
- VLOOKUP Not Working? Common Causes and FixesWhen VLOOKUP does not work, it is usually because the lookup value is not an exact match, the formula is searching the…
- VLOOKUP Not Working With Text? How to Fix ItWhen VLOOKUP will not find text, the most common causes are an approximate-match setting, extra or nonprinting spaces, or a mismatch between…
- VLOOKUP Table Array Not Working? Fix the RangeIf your VLOOKUP table array is not working, check that the lookup value is in the first column of the selected range,…
- VLOOKUP Not Working? Fix Common Excel Lookup ErrorsIf VLOOKUP is not working properly, start by using an exact match with FALSE, checking that the lookup value is in the…
- VLOOKUP Not Working with General Format? Fixes That WorkYes—VLOOKUP can work with cells set to General; that format alone does not prevent a lookup. If the formula fails, the usual…
- VLOOKUP Not Working With Leading Zeros? Here’s WhyVLOOKUP often fails with leading zeros because Excel may store one lookup key as text, such as “00123,” and the other as…
- VLOOKUP Not Working Even Though Values Match? FixesWhen VLOOKUP says values do not match, the cells often look identical but differ in data type, hidden characters, or the range…
- VLOOKUP Not Working? Fix Numbers Stored as TextYes—VLOOKUP can return #N/A when the lookup value is a number but the matching value in the table is stored as text,…
- VLOOKUP Not Working on Numbers? Fix the MatchWhen VLOOKUP will not match a number, the most common cause is that one value is stored as a number and the…
- VLOOKUP Not Working? Check Number FormatsYes—VLOOKUP can fail when one lookup value is a number and the matching value is text, even if both look identical on…
- VLOOKUP Not Working Between Workbooks? How to Fix ItWhen VLOOKUP fails between Excel workbooks, check the external reference, use an exact match, and confirm that the lookup value is in…
- VLOOKUP Not Working but Value Is There?If VLOOKUP says a value is missing even though you can see it, the usual causes are an inexact match setting, a…
- VLOOKUP Not Working? Fix Excel Formatting MismatchesYes—VLOOKUP can fail when a lookup value and the matching-looking cell are stored differently, such as the number 1042 versus the text…
- VLOOKUP Not Working Across Workbooks? Fix Common ErrorsVLOOKUP can search a range in another workbook, even when that workbook is closed, as long as the external reference points to…
- VLOOKUP Not Working Because of Number Format?Yes—VLOOKUP can fail when a lookup value is stored as a number but the matching value in the first column is stored…
- VLOOKUP in Excel Table Not Working? Fix ItWhen VLOOKUP in an Excel table is not working, first check that the value you are searching for is in the table’s…
- VLOOKUP Not Working? Fix the Common CausesIf VLOOKUP is not working correctly, first check that the lookup value is in the leftmost column of the selected range, use…
- VLOOKUP Match Not Working? Fix Common CausesIf VLOOKUP is not finding a match, first use exact-match mode by setting its fourth argument to FALSE, then check that the…
- VLOOKUP Dates Not Working? Find and Fix the CauseVLOOKUP dates usually fail because Excel is comparing a real date value with text, a date-time value, or a different date than…
- VLOOKUP Exact Match Not Working? Fix the Common CausesIf VLOOKUP exact match is not working, first make sure the formula ends with FALSE (or 0), then check that the lookup…
- VLOOKUP Approximate Match Not Working? Fix the CauseVLOOKUP approximate match usually fails because the lookup column is not sorted in ascending order, the lookup value and keys use different…
- VLOOKUP Circular Reference Error: Causes and FixesA VLOOKUP circular reference error means the formula depends, directly or indirectly, on its own result. VLOOKUP does not create circular references…
- VLOOKUP a ZIP Code Not Working? Fix Common Match ErrorsIf VLOOKUP cannot find a ZIP code, first check whether the lookup value and the ZIP codes in your table are the…
- Excel #VALUE! Error When a Linked Workbook Is ClosedYes—Excel can return #VALUE! when a formula uses certain functions, such as SUMIF or COUNTIF, to evaluate ranges in a linked workbook…