How to add IFNA to VLOOKUP?

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

Leave a Reply

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