IFERROR Function

How to Vlookup with Multiple Matches in Excel (with Easy Steps)

One of the most amazing and widely used functions of Excel is the VLOOKUP function. So far, we have learned to pull out a single match from a range ...

How to Find Partial Match in Two Columns in Excel (4 Methods)

Depending on the circumstances you may need to compare a couple of columns. The comparison can be done in many forms, one of them being 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, ...

How to Use VLOOKUP Formula in Excel with Multiple Sheets

Today we will show how to use the VLOOKUP formula with multiple sheets in Excel. Actually, one of the most important and widely used functions of ...

Return the Highest Value Using VLOOKUP Function in Excel

Undoubtedly, VLOOKUP is a versatile and handy function in Excel. Now, wouldn’t it be great if we could obtain the largest value with the VLOOKUP ...

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 (6 Examples)

Today I will talk about MS Excel’s popular and highly used function named the VLOOKUP function. This function can be used to extract, compare, shift, ...

VLOOKUP from Another Sheet in Excel (2 Cases)

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

Lookup and Return Multiple Values Concatenated into One Cell in Excel

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 Use RANK Function in Excel (6 Ideal Examples)

The simplest technique to establish a number’s relative position in a list of numbers is to sort the list in descending (from largest to smallest) or ...

How to Use HLOOKUP Function in Excel (8 Suitable Approaches)

In Microsoft Excel, HLOOKUP or Horizontal Lookup function is generally used to extract data from a table or an array based on searching for a ...

How to Use FILTER Function in Excel (10 Ideal Examples)

Excel 365 provides us with a powerful function for automatically filtering our datasets, named the FILTER function. It makes our task easier by using ...

How to Use IFERROR Function In Excel (4 Practical Examples)

In this tutorial, I am going to show you 4 practical examples of how to use the IFERROR function in excel. You can use these methods even in large ...

How to Sort Dates in Chronological Order in Excel (6 Easy Ways)

Microsoft Excel presents various sort options. Sorting may differ in terms of our needs and conditions. What we need to know is the correct and ...

How to Filter Data in Excel using Formula

To filter data in Excel is quite usual, often you need to filter data to find the sets of data you require to operate a particular operation. Today ...

ExcelDemy
Logo