Skip to content
- 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…Errors & fixes
- SUMIF Excel Shortcut: The Fastest Way to Use ItExcel has no dedicated keyboard shortcut that inserts a SUMIF formula automatically. The quickest method is to type the formula in a…Formulas & functions
- VLOOKUP in Excel: Return a Value from Another CellTo make VLOOKUP return a value from another cell, look up a key in the leftmost column of a table and specify…Formulas & functions
- 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…Errors & fixes
- If Excel Cell Contains Text: Useful Formulas and ExamplesWith the text to check in A2, use =IF(ISNUMBER(SEARCH("apple",A2)),"Yes","No") to test whether the cell contains “apple” anywhere; the result is Yes when…Formulas & functions
- 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…Errors & fixes
- 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…Errors & fixes
- 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…Errors & fixes
- COUNTIF in Excel: Count Empty Cells and Blank Cells EasilyIf your cells are in A2:A20, use =COUNTIF(A2:A20,"") to count empty cells. COUNTIF with an empty-string criterion counts genuinely blank cells and…Formulas & functions
- COUNTIF in Excel: Count Cells That Contain NumbersYes—COUNTIF can count cells that meet a numeric condition, and it can find text containing a particular digit. But if you simply…Formulas & functions
- 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…Errors & fixes
- COUNTIF Excel Cell Color: Methods That Work ReliablyExcel’s COUNTIF function cannot count cells by fill color on its own: its criteria are based on cell values, not formatting. To…Formulas & functions
- 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.…Errors & fixes
- SUMIF Excel Cell Reference: Syntax, Examples, and FixesWith criteria in A2:A6 and amounts in C2:C6, enter =SUMIF(A2:A6,"North",C2:C6) to add the amounts for rows marked North; if those amounts are…Formulas & functions
- SUMIF Excel Cell Value: Criteria, Examples & FixesTo make SUMIF use a value stored in a cell, put the cell reference in its criteria argument. With regions in A2:A7,…Formulas & functions
- SUMIF Excel: Sum Cells Containing Specific TextTo sum values when a related cell contains particular text, use SUMIF with asterisks as wildcards. With descriptions in A2:A100, amounts in…Formulas & functions
- Excel MATCH Errors: Causes, Fixes, and Formula ExamplesThe most common Excel MATCH error is #N/A: MATCH cannot find the lookup value in the specified range. For an exact lookup,…Formulas & functions
- Excel INDEX Errors: Common Causes, Meanings, and FixesAn Excel INDEX error usually means the requested row or column falls outside the range (#REF!), an index argument is invalid (#VALUE!),…Formulas & functions
- Excel INDEX Function: Syntax, Examples, and Common UsesYes. In the English-language version of Microsoft Excel, the function is called INDEX. It returns the value—or, in some cases, the reference—at…Formulas & functions
- INDEX Excel Arguments Explained: Syntax and ExamplesIn Excel, INDEX returns a value or reference at the intersection of a specified row and column in a range. Its arguments…Formulas & functions
- Excel VLOOKUP Column Index Number ExplainedIn Excel VLOOKUP, the column index number tells Excel which column to return a value from, counting from the left edge of…Formulas & functions
- 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…Errors & fixes
- XLOOKUP in Excel: What If the Return Cell Is Blank?If XLOOKUP finds a match whose return cell is truly empty, Excel normally displays 0—not a blank. With lookup keys in A2:A5,…Formulas & functions
- XLOOKUP in Excel: Find and Return Data From Another SheetYes. XLOOKUP can search a range on one worksheet and return the matching value from another range on that sheet; the sheet…Formulas & functions
- XLOOKUP Excel Cell References: A Practical GuideIn Excel, an XLOOKUP cell reference is the cell or range you tell the function to search or return; for example, =XLOOKUP(E2,A2:A5,B2:B5,"Not…Formulas & functions
- 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…Errors & fixes
- 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…Errors & fixes
- VLOOKUP Across Sheets in Excel: Formula and TipsYes. If the value to look up is in A2 on an Orders sheet, and a Product List sheet has lookup codes…Formulas & functions
- Excel conditional formatting based on another cell?Learn Excel conditional formatting from another cell with formula rules, reference examples, and fixes for common problems, so your highlights stay useful.How-to basics
- Xlookup vs vlookup?XLOOKUP defaults to exact matches and can return values from either side. See where VLOOKUP still fits and how to choose the…Formulas & functions