{"id":1534,"date":"2021-10-22T00:23:49","date_gmt":"2021-10-22T00:23:49","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=1534"},"modified":"2021-10-22T00:24:09","modified_gmt":"2021-10-22T00:24:09","slug":"vlookup-date-problems","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/vlookup-date-problems\/10089.html","title":{"rendered":"Vlookup date problems"},"content":{"rendered":"<p>I have really struggled to find a solution on the net but to no avial.<br \/>\nI have a date column [spreadsheet B]with the date linked to another spreadsheet A. The date format in both are dd\/mm\/yyy.<br \/>\nIn the spreadsheet B i have two column column S with for excample 01-Jan, 01-Feb, 01-Mar, 01-Apr and next to each a text value I want to lookup using the date column of the spreadsheet B<br \/>\nI have tried al the problem solving answers on the Net but always get a #N\/A or #value!<br \/>\nPlease help<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":3},"question-category":[53],"question_tags":[],"class_list":["post-1534","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\/1534","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=1534"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=1534"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=1534"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=1534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}