{"id":2659,"date":"2015-05-01T10:54:01","date_gmt":"2015-05-01T10:54:01","guid":{"rendered":"http:\/\/wiki.davelevy.info\/?p=2659"},"modified":"2023-12-30T13:48:04","modified_gmt":"2023-12-30T13:48:04","slug":"vlookup-vs-index-match","status":"publish","type":"post","link":"https:\/\/davelevy.info\/wiki\/vlookup-vs-index-match\/","title":{"rendered":"VLOOKUP vs INDEX ( MATCH)"},"content":{"rendered":"<p>How awesome is this! Excel =INDEX, is a matrix retrieve i.e. =INDEX(array, row, col) retrieves an entry from the two dimensional array. If we combine this with MATCH which returns a row number we can use these functions instead of =VLOOKUP, its allegedly faster too. MATCH operates on a column or linguistically a list.<br \/>\n<!--more--><\/p>\n<p>=INDEX(myarray, MATCH(querykey, querylist,matchkey), replycolumn)<\/p>\n<p>will return from the replycolumn, the element corresponding to the querykey. The matching key is 0,1,2 for equality and less than, greater than.<\/p>\n<ul>\n<li><a href=\"https:\/\/web.archive.org\/web\/20230926231231\/http:\/\/www.randomwok.com\/excel\/how-to-use-index-match\/\">http:\/\/www.randomwok.com\/excel\/how-to-use-index-match\/<\/a><\/li>\n<\/ul>\n<p>This needs example uploads; for another day.<\/p>\n<p><a href=\"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2015\/05\/indexmatch-w542.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2660\" src=\"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2015\/05\/indexmatch-w542.png\" alt=\"indexmatch-w542\" width=\"542\" height=\"340\" srcset=\"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2015\/05\/indexmatch-w542.png 542w, https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2015\/05\/indexmatch-w542-300x188.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/a><\/p>\n<p>The spreadsheet is <a title=\"an example spreadsheet (.ods)\" href=\"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2015\/05\/demo-indexmatch.ods\">here (.ods)<\/a><\/p>\n<p style=\"text-align: center;\">ooOOOoo<\/p>\n<p>I was pointed at this, http:\/\/spreadsheeto.com\/index-match\/ by the author, exceedingly comprehensive.<\/p>\n<p>If the source array is a table, the functions will prompt for the columns names.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How awesome is this! Excel =INDEX, is a matrix retrieve i.e. =INDEX(array, row, col) retrieves an entry from the two dimensional array. If we combine this with MATCH which returns a row number we can use these functions instead of =VLOOKUP, its allegedly faster too. MATCH operates on a column or linguistically a list.<\/p>\n","protected":false},"author":1,"featured_media":2663,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_share_on_mastodon":"0"},"categories":[3],"tags":[156,718,883,911,882],"class_list":["post-2659","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-excel","tag-index","tag-match","tag-technology","tag-vlookup"],"share_on_mastodon":{"url":"","error":""},"jetpack_featured_media_url":"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2015\/05\/excel-idxmatch.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/2659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/comments?post=2659"}],"version-history":[{"count":2,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/2659\/revisions"}],"predecessor-version":[{"id":9953,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/2659\/revisions\/9953"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media\/2663"}],"wp:attachment":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media?parent=2659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/categories?post=2659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/tags?post=2659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}