{"id":644,"date":"2017-02-20T04:45:44","date_gmt":"2017-02-20T04:45:44","guid":{"rendered":"http:\/\/xlfxs.com\/?p=644"},"modified":"2017-02-20T04:45:44","modified_gmt":"2017-02-20T04:45:44","slug":"match-fumction-just-a-simple-search","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=644","title":{"rendered":"MATCH fumction, just a simple search"},"content":{"rendered":"<p>To do a search in a column or a row, MATCH is the function to look for<\/p>\n<p>It is very simple, you set the value to look for and where to look, then of course there is some another option to set <b style=\"font-style: italic;\">how<\/b> to do the search.<\/p>\n<p>So, we are looking for 87 in column B (B:B) and we want the full perfect match (we out 0 in third box)<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2017\/02\/wp-1487608589150.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-752  aligncenter\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2017\/02\/wp-1487608589150.png\" alt=\"\" height=\"449\" width=\"454\"><\/a><\/p>\n<p>The result will be &#8230;.<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2017\/02\/wp-1487608607320.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-753  aligncenter\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2017\/02\/wp-1487608607320.png\" alt=\"\" height=\"445\" width=\"461\"><\/a><br \/>\nThe &#8220;9&#8221; here means the item was found as the cell number 9, as in 9th cell<\/p>\n<p>And because we did our selection as entire column (B:B), 9 here means row 9. This will also work if you did any range starting row 1, like B1:B200.<br \/>\nHowever, If we had that B:B input as B6:B13 instead (known range and not entire column)<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2017\/02\/wp-1487608964315.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-754  aligncenter\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2017\/02\/wp-1487608964315.png\" alt=\"\" height=\"464\" width=\"480\"><\/a><\/p>\n<p>The return will be the cell number within that range<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2017\/02\/wp-1487609085964.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-755  aligncenter\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2017\/02\/wp-1487609085964.png\" alt=\"\" height=\"430\" width=\"477\"><\/a><\/p>\n<p>In this case 4, as in 4th cell<\/p>\n<p>Hope that makes sense !!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To do a search in a column or a row, MATCH is the function to look for It is very simple, you set the value to look for and where to look, then of course there is some another option to set how to do the search. So, we are looking for 87 in column&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=644\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;MATCH fumction, just a simple search&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":753,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,37,6],"tags":[],"class_list":["post-644","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lookup_and_references","category-match","category-standard_functions"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=644"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/753"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}