Excel Formulas

Range Lookup with VLOOKUP in Excel (5 Examples)

While applying the VLOOKUP function in Microsoft Excel, we usually use the range lookup feature to extract the approximate or exact match from the ...

How to Use VLOOKUP for Partial Match in Excel (4 Ways)

VLOOKUP function is generally used for searching or finding any elements within a range or table in Excel. We can find any elements with partial ...

Partial Match with IF in Excel (4 Basic Operations)

IF is one of the most common functions in Excel. Depending on circumstances different logical operations can be performed through this function. We ...

How to Perform Partial Match String in Excel (5 Methods)

Whenever you are handling a wide range of data in your worksheet, partial matching or fuzzy matching is an effective way to find your match quickly. ...

Lookup Partial Text Match in Excel (5 Methods)

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

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)

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)

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

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)

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

IF and VLOOKUP Nested Function (7 Ways)

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

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

How to Count Duplicates in Excel (5 Methods)

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 Use VLOOKUP with COUNTIF (3 Ways)

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 Formula in Excel with Multiple Sheets

One of the most important and widely used functions of Excel is VLOOKUP. We can use the VLOOKUP function to look for some specific data in a single ...

ExcelDemy
Logo