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 …
LOOKUP function - Microsoft Support
Syntax. LOOKUP (lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments: lookup_value Required. A value that LOOKUP …
VLOOKUP function - Microsoft Support
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their …
Count unique values among duplicates - Microsoft Support
Count the number of unique values by using a filter. You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you …
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 …
Create, load, or edit a query in Excel (Power Query)
Create, load, or edit a query in Excel (Power Query) Applies To. Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load …
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF …
Create a Data Model in Excel - Microsoft Support
Use a Data Model to create a PivotTable or PivotChart. An Excel workbook can contain only one Data Model, but that model can contain multiple tables which can be used repeatedly …
Calculation operators and precedence in Excel - Microsoft Support
Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. There are four different types of calculation …
OFFSET function - Microsoft Support
This article describes the formula syntax and usage of the OFFSET function in Microsoft Excel. Description. Returns a reference to a range that is a specified number of rows and columns …
Create a simple formula in Excel - Microsoft Support
Create a simple formula in Excel. Applies To. You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign …