Skip to content
- XLOOKUP vs INDEX MATCH: Which Should You Use?XLOOKUP is the modern replacement for INDEX MATCH in Excel, offering a simpler formula with built-in error handling and the ability to…Formulas & functions
- XLOOKUP Concatenate Multiple Matches in ExcelYes, you can concatenate multiple matches in Excel by combining XLOOKUP with other functions—specifically, you cannot make XLOOKUP return multiple values directly,…Formulas & functions
- XLOOKUP Multiple Criteria in Excel: How ToTo use XLOOKUP with multiple criteria in Excel, you combine the criteria into a single lookup value using the ampersand (&) operator,…Formulas & functions
- Excel XLOOKUP Closest Match: Exact StepsTo find the closest match with XLOOKUP in Excel, use the match_mode argument set to -1 (exact match or next smaller) or…Formulas & functions
- Excel XLOOKUP Multiple Criteria: 2 Easy WaysThe simplest way to use XLOOKUP with multiple criteria is to combine the lookup values into one value with the & operator…Formulas & functions
- Excel x in Cell: What It Means & How to Fix ItThe x in an Excel cell almost always means the cell contains a formula that Excel cannot calculate or display correctly. The…Errors & fixes
- Excel Wrap Text in Quotes? How to Add Quotation MarksYes, you can wrap text in quotation marks in Excel, and there are several ways to do it depending on whether you…How-to basics
- Excel Not Calculating Automatically? Fix It NowIf your Excel workbook isn’t calculating automatically, the most likely cause is that the calculation mode is set to Manual. To fix…Errors & fixes
- Excel Won’t Sort by Date? Fix It in 5 StepsIf Excel won’t sort by date, the almost certain cause is that your dates are stored as text, not as real date…Errors & fixes
- Excel Won’t Run Macro? Fixes That WorkExcel won’t run your macro? The most common cause is that macros are disabled by default for security, and the fix is…VBA & macros
- Excel Won’t Let Me Password Protect? FixesExcel won’t let you password protect because the file is likely in a format that doesn’t support encryption, you’re trying to protect…Errors & fixes
- Excel Won’t Close? Fixes That Actually WorkIf Excel won’t close, press Ctrl+Alt+Delete to open Task Manager, select Microsoft Excel under Apps, and click End Task. Then reopen Excel…Errors & fixes
- Excel Weighted Moving Average: Formula & SetupIn Excel, a weighted moving average (WMA) is calculated by multiplying each data point in a rolling window by a set of…Formulas & functions
- Excel Weighted Average Rate Formula (Step-by-Step)The core Excel formula for a weighted average rate is =SUMPRODUCT(weights, rates) / SUM(weights) — put your weights in one column and…Formulas & functions
- Excel Weighted Average: Formula & Percentage TipsThe Excel formula for a weighted average percentage is =SUMPRODUCT(values, weights)/SUM(weights), where values are the percentages and weights are the relative importance…Formulas & functions
- Excel Weekly Schedule Template: How to Make OneThe quickest way to get an Excel weekly schedule template is to open Excel and search for “weekly schedule” in the template…How-to basics
- Excel Weekday Based on Date: Formula & ExamplesTo get the weekday from a date in Excel, use the WEEKDAY function: =WEEKDAY(A2) returns a number from 1 (Sunday) to 7…Formulas & functions
- Excel Web Pivot Table Calculated Field: How to AddYes, Excel for the web supports calculated fields in pivot tables, but with a key limitation: you cannot create or edit them…Charts & pivot tables
- Excel Weather Forecast: How to Pull Live DataYes, you can get a live weather forecast directly inside Excel by using the built-in Stocks and Geography data types (for current…How-to basics
- Excel Want to Merge? How to Combine CellsYes, you can merge cells in Excel, but it is rarely the best way to combine data. The Merge & Center button…How-to basics
- Excel VLOOKUP with Two Criteria: How-ToTo look up a value using two criteria in Excel, use XLOOKUP with a helper column that concatenates the two criteria, or…Formulas & functions
- Excel VLOOKUP with Duplicate Lookup ValuesWhen you use VLOOKUP on a column that contains duplicate lookup values, it returns the first match it finds, reading top to…Formulas & functions
- Excel VLOOKUP Return Value: How It Works & FixesIn Excel, VLOOKUP returns the value in a specified column that sits in the same row as the lookup value you searched…Formulas & functions
- Excel VLOOKUP Numbers Stored as Text: FixesThe direct answer: when VLOOKUP returns #N/A because your lookup value is a number but the data is stored as text (or…Formulas & functions
- Excel VLOOKUP Not Finding Duplicates? Fix ItVLOOKUP does not find duplicates because it only returns the first match for a lookup value, and it treats values that look…Errors & fixes
- Excel VLOOKUP Max Value Based on CriteriaTo find the maximum value in one column based on a criteria in another column, use an array formula like =MAX(IF(A2:A20="North",B2:B20)) (confirm…Formulas & functions
- Excel VLOOKUP with Multiple Criteria: INDEX-MATCHThe best way to do a VLOOKUP with multiple criteria in Excel is to use the INDEX and MATCH functions together, because…Formulas & functions
- Excel VLOOKUP Duplicate Values: How to Handle ThemThe short answer: VLOOKUP returns the first matching value when duplicates exist in the lookup column, so it does not show all…Formulas & functions
- Excel VLOOKUP Classes: Free Options & Where to StartYes, you can learn VLOOKUP in Excel completely free. The best no-cost options are Microsoft’s own support pages, YouTube tutorials from reputable…Formulas & functions
- Excel VLOOKUP with Multiple Criteria: 4 WaysThe simplest way to do a VLOOKUP with multiple criteria in Excel is to add a helper column that combines the criteria…Formulas & functions