how to

How to add IFNA to VLOOKUP?

Posted on by SaeedBaba

In VLOOKUP 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 VLOOKUP function.

How to add IFNA to VLOOKUP?

=IFNA(VLOOKUP(A2,A5:D14,2,FALSE),"not available") ----->>>>answer is  not available

Related posts:

Default ThumbnailFALSE function in Excel Default ThumbnailUNIQUE Function in Excel Default ThumbnailRTD Function in Excel Default ThumbnailExcel IMLOG2 function
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 *