Latest Blog Posts - Page 540 of 584

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 ...

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

10 Best Practices with VLOOKUP in Excel

Jun 21, 2024

Introduction to the VLOOKUP Function Function Objective: The VLOOKUP function is used to look for a given value in the leftmost ...

Use VLOOKUP to Find Multiple Values with Partial Match in Excel

Nov 11, 2025

Circumstances may demand a partial match with multiple values. Our agenda for today is to assist you in performing a partial match using VLOOKUP with ...

Use VLOOKUP to Find Multiple Values with Partial Match in Excel

How to Use the VLOOKUP Ascending Order in Excel (3 Ways)

Nov 11, 2025

The VLOOKUP function is a game-changer when you have to retrieve information from a range of data in the same or different worksheets. This function ...

How to Use the VLOOKUP Ascending Order in Excel (3 Ways)

IF and VLOOKUP Nested Function in Excel: 5 Practical Uses and 2 Ways of Handling Errors

Jun 16, 2024

Practical Uses 1. How to Match VLOOKUP Output with a Specific Value Let’s say we want to determine how much inventory we have for a particular ...

IF and VLOOKUP Nested Function in Excel: 5 Practical Uses and 2 Ways of Handling Errors

How to Use VLOOKUP to Find Partial Text from a Single Cell

Jul 5, 2024

We have a data set with the Names, Authors, and Book Types of some books from a bookshop named Martinez Bookstore. We'll look for a partial text ...

How to Use VLOOKUP to Find Partial Text from a Single Cell

How to Use VLOOKUP Function to Compare Two Lists in Excel

May 28, 2024

Here we have a dataset of equipment lists for two gyms. We will compare the lists using the VLOOKUP function. Method 1 - Compare Two Lists ...

How to Use VLOOKUP Function to Compare Two Lists in Excel

How to Count Duplicates in Excel

Jun 16, 2024

We will use the following dataset of items and their quantities and grades to showcase how you can count duplicate items. Method 1 - Using ...

Excel Auto Sort When Data Changes (9 Examples)

May 31, 2024

In this article, we'll demonstrate how to use the SORT function or combine it with other functions to sort data automatically when data is changed ...

Excel Auto Sort When Data Changes (9 Examples)

How to Use VLOOKUP with COUNTIF (3 Easy Ways)

Jul 3, 2024

Example 1 - Count the Occurrences Using VLOOKUP and COUNTIF Functions Let’s consider a dataset of student attendance over a week (based on student ...

How to Use VLOOKUP with COUNTIF (3 Easy Ways)

How to Use VLOOKUP with Two Lookup Values in Excel

Jul 3, 2024

We have a table containing the roll of honor for the few major European football leagues. Using this dataset, we will VLOOKUP with two lookup values. ...

How to Use VLOOKUP with Two Lookup Values in Excel

How to Use VLOOKUP Formula in Excel with Multiple Sheets

May 21, 2024

An Introduction to Excel’s VLOOKUP Function =VLOOKUP(lookup_value,table_array,col_index_num,) This function takes a range of cells called ...

How to Use VLOOKUP Formula in Excel with Multiple Sheets

Return the Highest Value Using VLOOKUP Function in Excel

Jun 14, 2024

Introduction to VLOOKUP Function The VLOOKUP function looks for a value in the left-most column of a table array and then returns a value in ...

Return the Highest Value Using VLOOKUP Function in Excel

INDEX MATCH with 3 Criteria in Excel (4 Examples)

Apr 16, 2024

Method 1 - INDEX MATCH with 3 Criteria in Excel (Array Formula) The following dataset contains a number of Xiaomi smartphone models with ...

INDEX MATCH with 3 Criteria in Excel (4 Examples)

How to Use VLOOKUP for Multiple Columns in Excel?

Apr 12, 2024

Method 1 - Getting Values from Multiple Columns Using Excel VLOOKUP Function Consider the following starting dataset, containing Product ...