IFNA Function

### How to Ignore #N/A Error When Getting Average in Excel

Microsoft Excel offers unique functions, one of which is the AVERAGE function. This computes the average of a value in a range of cells. However, ...

### How to Use XLOOKUP to Return Blank Instead of 0

Need to learn how to use XLOOKUP to return blank instead of 0? XLOOKUP is a widely used function. Using this function, we can extract data from one ...

### How to Apply VLOOKUP to Return Blank Instead of 0 or NA

Whenever we lookup values using the VLOOKUP values, if there is no match, then it will show a “#N/A” error, and when there are 0 values, it will show ...

### How to Find Second Match with VLOOKUP in Excel (2 Simple Methods)

Finding specific cell values manually from a range in Excel datasheets is a really inconvenient process. This article will show you the simple ...

### How to SUM Ignore N/A in Excel (7 Simple Ways)

In a large dataset, there is a possibility of having some null or blank cells. The SUM function doesn’t work with #N/A values but there are several ...

### How to Find Value in Range in Excel (3 Quick Methods)

Circumstances may demand you to find value from a range. Finding, and retrieving are common operations in Excel. Today we will show you how to find ...

### How to Use IF ISNA Function with VLOOKUP in Excel

Today I will be showing how you can use the VLOOKUP in combination with the IF and ISNA functions of Excel. One of the most important and widely ...

### How to Use VLOOKUP to Find Duplicates in Two Columns

In this tutorial, I am going to show you 8 quick tricks to use VLOOKUP to find duplicates in two columns. You can quickly use these methods even in ... Advanced Excel Exercises with Solutions PDF  