{"id":2649,"date":"2020-11-28T12:44:19","date_gmt":"2020-11-28T20:44:19","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=2649"},"modified":"2020-12-20T21:26:34","modified_gmt":"2020-12-21T05:26:34","slug":"how-to-vlookup-and-return-zero-instead-of-n-a-in-excel","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=2649","title":{"rendered":"How VLOOKUP Return Zero Instead Of #N\/A in Excel?"},"content":{"rendered":"\n

To return zero instead of #N\/A when the VLOOKUP function cannot find the correct relative result, you just need to change the ordinary formula to another one in Excel.<\/p>\n\n\n\n

Select the cell you want to use VLOOKUP function, and type this formula =IFERROR(VLOOKUP(A13,$A$2:$C$10,3,0),0), drag the autofill handle to the range you need. See screenshot:
\"doc-vlookup-return-0-2\"<\/p>\n\n\n\n

Tips:<\/strong>
(1) In the above formula, A13 is the lookup value, A2:C10 is the table array range, and 3 is the index column number. The last 0 is the value you want to show when the VLOOKUP cannot find the relative value.
(2) This method will replace all kinds of errors with the number 0, including #DIV\/0, #REF!, #N\/A, etc.<\/p>\n\n\n\n

Ref: https:\/\/www.extendoffice.com\/documents\/excel\/2628-excel-vlookup-return-instead-of-n-a.html<\/p>\n","protected":false},"excerpt":{"rendered":"

To return zero instead of #N\/A when the VLOOKUP function cannot find the correct relative result, you just need to change the ordinary formula to another one in Excel. Select the cell you want to use VLOOKUP function, and type this formula =IFERROR(VLOOKUP(A13,$A$2:$C$10,3,0),0), drag the autofill handle to the range you need. See screenshot: Tips:(1) In Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[10,18],"tags":[446],"class_list":["post-2649","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-vlookup"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t