how to

How to add IFNA to HLOOKUP

Posted on by SaeedBaba

In the HLOOKUP function, if the data is not available in the database, by default, it cannot display a sentence in the output and it shows the #NA error.

As a result, you should always use IFNA function with HLOOKUP function.

How to add IFNA to HLOOKUP?
=IFNA(HLOOKUP(A2,A5:D14,2,FALSE),"not available") ----->>>>answer is  not available

IFNA function arguments

=IFNA(Value section,Value_if_na section)
  • This function has just 2 Arguments.
  • In Value section, we can enter any value or expression or reference.
  • In Value_if_na section we can enter any value or expression or reference.
  • The arguments of IFNA function are required and not optional.

Related posts:

Default ThumbnailFALSE function in Excel Default ThumbnailExcel COLUMNS Function vlookup not workingMost important reason why vlookup not working Default ThumbnailRTD Function in Excel
SaeedBaba

I'm an Excel Expert with 10+ of experience, specializing in Excel Worksheets, Advanced Charting, Functions, data visualization, pivot tables, and data analytics. I help businesses to manage projects and analyze data with the use of Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *