IFERROR Function

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

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)

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

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

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)

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)

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

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

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)

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

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)

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

How to Return the Highest Value Using VLOOKUP in Excel

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)

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

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

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

ExcelDemy
Logo