{"id":907,"date":"2021-10-19T07:55:42","date_gmt":"2021-10-19T07:55:42","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=907"},"modified":"2021-10-19T07:57:12","modified_gmt":"2021-10-19T07:57:12","slug":"solved-vlookup-returns-00-01-1900-instead-of-blank","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/vlookup-returns-00011900-instead-of-blank\/21180.html","title":{"rendered":"Solved VLOOKUP Returns 00\/01\/1900 Instead Of Blank"},"content":{"rendered":"<p>Hi all,<\/p>\n<p>I have a formula which was originally showing #N\/A as well as 0\/01\/1900.<\/p>\n<p>I am using Excel 2016<\/p>\n<p>I was able to get rid of the #N\/A but I cannot get rid of the 0\/01\/1900 any suggestions would be awesome<\/p>\n<p>The formula I am using is as follows<\/p>\n<p>=IFERROR(VLOOKUP($A2,&#8217;CoP Expiry&#8217;!$A$2:$B$6000,2,FALSE),&#8221;&#8221;)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":7},"question-category":[53],"question_tags":[],"class_list":["post-907","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/907","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=907"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=907"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=907"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}