ExcelDemy - Page 4 of 53 - Free Excel Tutorial & Online Courses

Lookup Partial Text Match in Excel (5 Methods)

Sep 23, 2021 Excel Formulas

In Microsoft Excel, there are several useful methods to lookup partial text matches and then extract data based on that specific match. In this ...

COUNTIF Cell That Contains a Specific Text in Excel

Sep 23, 2021 Excel Formulas

Today I will be showing how you can count cells that contain a specific text within it. I will show both case-insensitive and sensitive ways to ...

How to VLOOKUP Partial Text in Excel (With Alternatives)

Sep 23, 2021 Excel Formulas

In MS Excel, instead of searching for something with full text we may have to use partial text. Where the lookup value will be returned based on the ...

COUNTIF Partial Match (Couple of Easy Approaches)

Sep 23, 2021 Excel Formulas

COUNTIF is one of the most frequently used functions in Excel. A lot of tasks can be done using this function, one of them is the partial match. ...

10 Best Practices with VLOOKUP in Excel

Sep 23, 2021 Excel Formulas

In Microsoft Excel, the VLOOKUP function is generally used to extract data based on a lookup value in a column or a range of cells. In this article, ...

VLOOKUP Partial Match Multiple Values (3 Approaches)

Sep 23, 2021 Excel Formulas

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

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

Sep 12, 2021 Uncategorized

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

IF and VLOOKUP Nested Function (7 Ways)

Sep 23, 2021 Excel Formulas

IF and VLOOKUP functions are some of the most used functions in MS Excel for various purposes. The IF statement is used for conditioning purposes and ...

VLOOKUP Partial Text from a Single Cell in Excel

Sep 23, 2021 Excel Formulas

One of the most important and widely used functions of Excel is VLOOKUP. We can use the VLOOKUP function of Excel to look for any data related to any ...

VLOOKUP To Compare Two Lists (Same or Different Sheets)

Sep 23, 2021 Excel Basics

Performing a comparison between a couple of lists is one of the familiar tasks in Excel. Today we are going to show how to compare two lists using ...

How to Count Duplicates in Excel (5 Methods)

Sep 23, 2021 Excel Formulas

While working with a large amount of data or compiling multiple worksheets into a bigger one, duplicate values, columns or rows may appear. Sometimes ...

How to Create Custom Sort List in Excel

Sep 23, 2021 Excel Basics

While working in Excel, we often have to sort a range of cells according to our own needs. Sorting these manually may take a lot of time and it is ...

Excel Auto Sort When Data Changes (9 Examples)

Sep 23, 2021 Excel Basics

In Microsoft Excel, there are numerous procedures to auto-sort a table or an array if someone changes data. In this article, you'll learn how you can ...

How to Use VLOOKUP with COUNTIF (3 Ways)

Sep 23, 2021 Excel Formulas

VLOOKUP and COUNTIF are mostly used and powerful functions in MS Excel. VLOOKUP is used to find any specific data from any table and the COUNTIF ...

VLOOKUP with Two Lookup Values

Sep 23, 2021 Excel Basics

Depending on circumstances you may need to use multiple lookup values with VLOOKUP. For easing your effort, today we are going to show you how to use ...

Latest Posts