Excel shows the #VALUE! error when your formula includes cells that have different data types (text and numeric values). The #VALUE! error is also shown when a formula references one or …

When there is a cell reference to an error value, IF displays the #VALUE! error. Solution: You can use any of the error-handling formulas such as ISERROR, ISERR, or IFERROR along with IF. …

This topic provides help for the most common scenarios for the #VALUE! error in the AVERAGE or SUM functions.

The most common cause of the #N/A error is with XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, or MATCH functions if a formula can't find a referenced value. For example, your lookup value …

This topic explains the common scenarios where you encounter the #VALUE! error when using INDEX and MATCH functions together in a formula.

This topic lists the more common causes of the #VALUE! error in the SUMIF and SUMIFS functions and how to resolve them. Problem: The formula refers to cells in a closed workbook. …

When your formula has a reference to a name not defined in Excel, you see the #NAME? error. See the following example of a SUM function referring to Profit, which is an undefined name in …

If you work with VLOOKUP, there is a good chance you may have run into the #VALUE! error several times. This topic lists the most common problems that may occur with VLOOKUP, and …

The #REF! error shows when a formula refers to a cell that's not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.

If a formula cannot correctly evaluate a result, Excel displays an error value, such as #####, #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each error type has different …