{"id":5777,"date":"2021-11-16T13:56:22","date_gmt":"2021-11-16T13:56:22","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=5777"},"modified":"2021-11-16T13:56:56","modified_gmt":"2021-11-16T13:56:56","slug":"excel-formula-using-current-month-to-locate-a-value","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-formula-using-current-month-to-locate-a-value\/18217.html","title":{"rendered":"Excel Formula: Using Current Month To Locate A Value"},"content":{"rendered":"<p>I would like to have a formula that will take the current month you open the spreadsheet and locate that month and year on another tab in the same workbook and return the value that is on that row in the tab.<br \/>\nFor Example. Today is May 9 , 2013. In cell A1, I want excel to find 5\/1\/13 in another tab and return the value that is always in column C, but the cell number will change based on the month.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":5},"question-category":[53],"question_tags":[],"class_list":["post-5777","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\/5777","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=5777"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=5777"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=5777"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=5777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}