IFNA Function Archives

How to Compare Multiple Columns Using VLOOKUP in Excel (5 Methods)

May 25, 2022 Excel Formulas

Often, we have to work with multiple columns in Excel to search for the common data or to find out the missing values. On the other hand, the VLOOKUP ...

How to Set Cell to Blank in Formula in Excel (6 Ways)

May 25, 2022 Excel Formulas 1

When performing calculations in Excel, sometimes we want the results to be displayed as a blank cell if the computation does not meet our needs. When ...

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

May 24, 2022 Excel Formulas

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 Use IFNA Function in Excel (2 Examples)

Jun 8, 2022 Excel Functions

The IFNA function is primarily used to handle the #N/A errors. It returns a specific value as per your instruction if such #N/A error occurs; ...

How to Remove Error in Excel (8 Methods)

May 18, 2022 Excel Formulas

In a worksheet, while working with functions there exist possibilities of appearing errors as all data are not well organized. Though it is so ...

SUM Ignore N/A in Excel( 7 Easiest Ways)

May 16, 2022 Excel Formulas

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

How to Find Value In Range in Excel (3 Methods)

May 14, 2022 Excel Formulas

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

Find And Replace Multiple Values in Excel (6 Quick Methods)

May 14, 2022 Excel Basics

In Microsoft Excel, it’s a usual scenario to find and replace multiple text or numeric values. You can use the Find and Replace command, apply ...

How to Use IF ISNA Function with VLOOKUP in Excel (3 Examples)

Jun 5, 2022 Excel Formulas

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

VLOOKUP to Find Duplicates in Two Columns (2 Ways)

Feb 26, 2022 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 ...