Excel Formulas Archives - Page 98 of 112

How to Reference Worksheet Name in Formula in Excel

Jun 24, 2024

Let’s consider the Sales Data for January in the “January” worksheet, which depicts the “Product Name” and the “Sales” in USD. We have the ...

How to Reference Worksheet Name in Formula in Excel

How to Use INDIRECT, INDEX, and MATCH Functions in Excel

May 15, 2024

Method 1 – Using the INDIRECT Function in a Table Steps: Select cell C15. Enter the following formula: ...

How to Use INDIRECT, INDEX, and MATCH Functions in Excel

XLOOKUP vs INDEX-MATCH in Excel (All Possible Comparisons)

Jun 30, 2024

Introduction to the XLOOKUP Function The XLOOKUP function finds a specific value within a range of cells or an array. It then returns the ...

XLOOKUP vs INDEX-MATCH in Excel (All Possible Comparisons)

INDEX MATCH Formula with Multiple Criteria in Different Sheet

Jul 9, 2024

Method 1 - INDEX-MATCH Formula with Multiple Criteria for Columns Only We'll use a Monthly Sales Report of a particular organization, containing the ...

INDEX MATCH Formula with Multiple Criteria in Different Sheet

Use Excel VBA VLOOKUP to Find Values in Another Worksheet

Jul 8, 2024

In this article, we will demonstrate how to use the Excel VBA VLOOKUP in another worksheet. Suppose we have the dataset below, stored in the sheet ...

Use Excel VBA VLOOKUP to Find Values in Another Worksheet

How to Use SUMPRODUCT with Criteria in Excel (5 Methods)

Jun 26, 2024

Excel SUMPRODUCT Function: Overview Technically, the “SUMPRODUCT” function remits the summation of the values of corresponding arrays or ranges. ...

How to Use SUMPRODUCT with Criteria in Excel (5 Methods)

How to Use INDEX and Match for Partial Match: 2 Easy Ways

May 21, 2024

Method 1 - Using Wildcard Combining with INDEX and MATCH Functions for Finding Data with Partial Match 1.1 Match Starting Characters (Value&“*”) ...

How to Use INDEX and Match for Partial Match: 2 Easy Ways

How to Find Partial Match in Two Columns in Excel (4 Methods)

Apr 23, 2024

Here we have a dataset of a few famous athletes from different sports. Using this dataset, we will find partial matches within two columns. ...

How to Find Partial Match in Two Columns in Excel (4 Methods)

How to Use the SUMPRODUCT IF in Excel (2 Methods)

May 22, 2024

Method 1 - Applying the SUMPRODUCT IF Formula with One Criteria We have a data table with some fruit Items given with “Region,” “Qty,” and “Price.” ...

How to Use the SUMPRODUCT IF in Excel (2 Methods)

Range Lookup with VLOOKUP in Excel (5 Examples)

Apr 26, 2024

Example 1 - Assigning Letter Grades in a Mark Sheet Through a Range Lookup with the Excel VLOOKUP Function The generic formula of the ...

Range Lookup with VLOOKUP in Excel (5 Examples)

How to Use the IF Function to Find a Partial Match in Excel – 6 Methods

Aug 14, 2024

The sample dataset showcases the Addresses of Employees in a company. To check whether a a partial match for a given state name is in the ...

How to Use the IF Function to Find a Partial Match in Excel – 6 Methods

How to Perform Partial Match of String in Excel (8 Easy Methods)

Jul 3, 2024

Download the Practice Workbook Partial match string.xlsx 8 Methods to Perform a Partial Match for a String in Excel Method 1 - Using ...

How to Perform Partial Match of String in Excel (8 Easy Methods)

Lookup Partial Text Match in Excel (5 Methods)

Apr 30, 2024

Method 1 - Using the VLOOKUP Function to Lookup a Partial Text Match in Excel In the following picture, there is a table containing the ...

Lookup Partial Text Match in Excel (5 Methods)

How to Apply the COUNTIF Function When a Cell Contains Specific Text – 3 Methods

Aug 2, 2024

This is the sample dataset. Method 1 - Counting the Exactly Matched String Steps: Create four extra fields. To count how many ...

How to Apply the COUNTIF Function When a Cell Contains Specific Text – 3 Methods

How to Use the COUNTIF Function for Partial Matches in Excel (3 Methods)

Jul 15, 2024

Dataset Overview We'll use the following dataset. It contains several Book Name along with their respective details. Method 1 - Use the ...