IFERROR Function Archives

Create a Unique List in Excel Based on Criteria (9 Methods)

Sep 26, 2021 Advanced Excel

In Microsoft Excel, several methods are available to create a unique list under multiple criteria. The unique list is generally prepared to remove ...

How to Populate a List Based on Cell Value in Excel (6 Ways)

Sep 26, 2021 Advanced Excel

In MS Excel, sometimes we may need to determine or find values based on some criteria or condition from a list. Assuming we have a task plan with the ...

How to Auto Populate Cells in Excel Based on Another Cell

Sep 26, 2021 Advanced Excel

How good would it be if cells get filled automatically? Most of the time we will love that. Today we are going to show you how to auto-populate cells ...

How to Use VLOOKUP for Partial Match

Sep 23, 2021 Excel Formulas

There may arise a situation where you need to perform a partial matching within VLOOKUP. To assist you, today we are going to show you how to operate ...

VLOOKUP and Return All Matches in Excel (7 Ways)

Sep 23, 2021 Excel Formulas

There are several ways to apply VLOOKUP or vertical lookup in Microsoft Excel to return data based on multiple matches. In this article, you’ll get ...

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

Oct 10, 2021 Excel Formulas

Today I will make a comparative analysis on XLOOKUP vs INDEX-MATCH in Excel. In the earlier versions of Excel, we used to use the HLOOKUP, the ...

VLOOKUP to Find Duplicates in Two Columns

Sep 23, 2021 Excel Formulas

You may need to compare two columns in Excel to find duplicates or unique. In this article, we are going to show you how to find duplicates from two ...

VLOOKUP with Multiple Matches in Excel

Oct 10, 2021 Excel Formulas

Today I will be showing how to use VLOOKUP to extract multiple matches in Excel. One of the most amazing and widely used functions of Excel is ...

Excel Partial Match Two Columns (4 Simple Approaches)

Sep 23, 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 ...

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 Formula in Excel with Multiple Sheets (4 Simple Tips)

Oct 10, 2021 Excel Formulas

Today I will be showing how to use the VLOOKUP formula across multiple sheets in Excel. One of the most important and widely used functions of ...

VLOOKUP Formula in Excel with Multiple Sheets (4 Simple Tips)

How to Return the Highest Value Using VLOOKUP in Excel

Sep 23, 2021 Excel Formulas

The VLOOKUP function is one of the most useful and at the same time one of the most sophisticated functions in Excel. This function not only helps ...

INDEX MATCH with 3 Criteria in Excel (4 Examples)

Sep 23, 2021 Excel Formulas

To extract data with different criteria or conditions in Microsoft Excel, the combination of INDEX and MATCH functions is best suited so far. In this ...

How to Use VLOOKUP for Multiple Columns in Excel

Sep 23, 2021 Excel Formulas

Today I will talk about MS Excel’s popular and highly used function name VLOOKUP. This function can be used to extra, compare, shift, or search data ...

VLOOKUP from Another Sheet in Excel

Sep 23, 2021 Excel Formulas

When you have to deal with massive data from multiple worksheets across your Excel workbook, the VLOOKUP function is your savior. The VLOOKUP ...