This function will return a specified value if your given expression results in an #N/A error. Only the #N/A! error will result in the alternate value.

## Syntax

IFNA(Expression, Value if #N/A!)

• Expression (required) – This is part of the formula that is checked for an #N/A error.
• Value if #N/A! (required) – This is the value that is returned if the expression results in an #N/A! error.

## Example

In this example we use the IFNA function with a VLOOKUP function. If the VLOOKUP function results in an #N/A! error (ie the lookup value was not found), then the IFNA function will return the text “Item not found”.

``=IFNA(VLOOKUP(D2,\$A\$2:\$B\$6,2,FALSE),"Item not found")``
{"ft_lang_label":"__label__en","ft_lang_prob":0.71845806,"math_prob":0.8769974,"size":667,"snap":"2020-34-2020-40","text_gpt3_token_len":178,"char_repetition_ratio":0.14781298,"word_repetition_ratio":0.0,"special_character_ratio":0.25787106,"punctuation_ratio":0.12587413,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9685008,"pos_list":[0,1,2],"im_url_duplicate_count":[null,2,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2020-09-26T22:13:48Z\",\"WARC-Record-ID\":\"<urn:uuid:c1665aa0-2215-4afd-a0ef-b1fe6063024a>\",\"Content-Length\":\"63642\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:daf22d42-9ee1-4911-a6ae-d5a16be79197>\",\"WARC-Concurrent-To\":\"<urn:uuid:8f3848e4-c379-4fd1-b343-b12d9241491c>\",\"WARC-IP-Address\":\"104.197.105.151\",\"WARC-Target-URI\":\"https://www.howtoexcel.org/functions/logical/ifna-function/\",\"WARC-Payload-Digest\":\"sha1:RHPSA3PRGKQK7PDCQ6PR7BV4CX4Z4EP4\",\"WARC-Block-Digest\":\"sha1:MVT2IUSOYKIAPWT2SCNNBPY7MGJPN43Q\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2020/CC-MAIN-2020-40/CC-MAIN-2020-40_segments_1600400245109.69_warc_CC-MAIN-20200926200523-20200926230523-00346.warc.gz\"}"}