IF Function Archives - Page 2 of 9

Excel Partial Match Two Columns (4 Simple Approaches)

Nov 25, 2021 Excel Formulas

Depending on the circumstances you may need to compare a couple of columns. The comparison can be done in many forms, one of them is partial ...

How to use SUMPRODUCT IF in Excel

Oct 27, 2021 Excel Formulas

SUMPRODUCT is an extremely resourceful function with many purposes. When you are comparing data between two or more ranges and calculating with ...

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

Nov 17, 2021 Excel Formulas

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

How to Use IF Partial Match in Excel (4 Basic Operations)

Nov 25, 2021 Excel Formulas

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)

Nov 17, 2021 Excel Formulas

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

COUNTIF Partial Match in Excel (2 or More Approaches)

Nov 25, 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. ...

IF and VLOOKUP Nested Function (7 Ways)

Nov 8, 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 To Compare Two Lists in Excel (2 or More Ways)

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

Nov 9, 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 ...

Minimum Value Based on Multiple Criteria in Excel (7 Ways)

Sep 23, 2021 Excel Formulas

MS Excel provides a simple function called MIN which returns a minimum value from any range. But there might be a case where we need to find or ...

Lookup and Return Multiple Values Concatenated into One Cell in Excel

Sep 23, 2021 Excel Formulas

In Microsoft Excel, there are a number of suitable techniques to lookup a criterion and then return multiple values concatenated into one cell based ...

How to Write Greater Than or Equal To in Excel IF Function

Sep 28, 2021 Excel Basics

The IF function in Excel is a logical function where you may need to use various comparison operators: equal, not equal, greater than, less than, and ...

How to Use MAX IF Function in Excel

Sep 28, 2021 Excel Formulas

While working in excel, we need to find the maximum value under a given condition. The combination of the MAX function and IF function can help you ...

How to Use Excel IF Function with Range of Values

Oct 10, 2021 Excel Formulas

IF is one of the most useful and widely used functions of Excel. Today I will be showing how to use this IF function with a wide range of values, ...