XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
Lookup and reference functions (reference) - Microsoft Support
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
How to correct a #REF! error - Microsoft Support
How to correct a #REF! error. Applies To. 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. #REF! error caused by deleting a column. Example - VLOOKUP with incorrect range references. INDEX with incorrect row or column reference.
Repair a corrupted workbook - Microsoft Support
When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook: Click File > Open. Click the location and folder that contains the corrupted workbook.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Overview of formulas in Excel - Microsoft Support
If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro. Formulas in-depth.
Create a relationship between tables in Excel - Microsoft Support
Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
Share your documents - Microsoft Support
You can share your documents for free using Microsoft 365, regardless of whether you or the recipient have a subscription or a Microsoft account. The act of sharing maybe successful, however, the recipient may not be able to open the file because of the Sensitivity label on it.
Create a PivotTable to analyze worksheet data - Microsoft …
One trick is to use Find & Replace (Ctrl+H) > Find what > " Sum of ", and then Replace with > leave blank to replace everything at once instead of manually retyping. Instead of using a calculation to summarize the data, you can also display it as a percentage of a field.
Import XML data - Microsoft Support
Click Developer > Import. If you don't see the Developer tab, see Show the Developer tab. In the Import XML dialog box, locate and select the XML data file (.xml) you want to import, and click Import. If the XML data file doesn't refer to a schema, …
Create a PivotChart - Microsoft Support
Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.