{"id":636,"date":"2015-01-02T21:51:04","date_gmt":"2015-01-03T02:51:04","guid":{"rendered":"http:\/\/matthannan.net\/blog\/?p=636"},"modified":"2015-01-02T21:51:04","modified_gmt":"2015-01-03T02:51:04","slug":"say-goodbye-to-vlookup-and-hello-to-index-match-eimagine-technology-group","status":"publish","type":"post","link":"https:\/\/matthannan.net\/blog\/say-goodbye-to-vlookup-and-hello-to-index-match-eimagine-technology-group\/","title":{"rendered":"Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group"},"content":{"rendered":"<p><code>=INDEX(nodes.csv!$A$1:$A$31,MATCH(C2,nodes.csv!$B$1:$B$31,0))<\/code><\/p>\n<p><a href='http:\/\/thinketg.com\/say-goodbye-to-vlookup-and-hello-to-index-match\/'>Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>=INDEX(nodes.csv!$A$1:$A$31,MATCH(C2,nodes.csv!$B$1:$B$31,0)) Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[237],"class_list":["post-636","post","type-post","status-publish","format-standard","hentry","category-geek","tag-excel"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2NxlE-ag","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1082,"url":"https:\/\/matthannan.net\/blog\/names-change\/","url_meta":{"origin":636,"position":0},"title":"Names Change","author":"matthannan","date":"30 April 2017","format":false,"excerpt":"In an effort to clear my desk fo at least one piece of paper, I am going to write this blog post about my mother's, mother's father, David T. Atkinson Sr. At least, that is what he thought his name was. Turns out...maybe not so much. You may recall that\u2026","rel":"","context":"In &quot;Genealogy&quot;","block_context":{"text":"Genealogy","link":"https:\/\/matthannan.net\/blog\/category\/genealogy\/"},"img":{"alt_text":"1893, John Atkinson Birth Record","src":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2017\/04\/1893_JohnAtkinson_BirthRecord.png?fit=900%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2017\/04\/1893_JohnAtkinson_BirthRecord.png?fit=900%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2017\/04\/1893_JohnAtkinson_BirthRecord.png?fit=900%2C1200&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2017\/04\/1893_JohnAtkinson_BirthRecord.png?fit=900%2C1200&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1633,"url":"https:\/\/matthannan.net\/blog\/__trashed\/","url_meta":{"origin":636,"position":1},"title":"John Draddy, more","author":"matthannan","date":"7 September 2019","format":false,"excerpt":"I've previously covered poor John Draddy, my 3rd great grandfather, who was killed in a construction explosion. What I see I am missing from this blog is that I sent off for the list of those buried in his grave with him. There are seven others in there with him,\u2026","rel":"","context":"In &quot;Genealogy&quot;","block_context":{"text":"Genealogy","link":"https:\/\/matthannan.net\/blog\/category\/genealogy\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2019\/09\/Headstone-Calvary-8-61-T-13-reverse.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2019\/09\/Headstone-Calvary-8-61-T-13-reverse.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2019\/09\/Headstone-Calvary-8-61-T-13-reverse.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2019\/09\/Headstone-Calvary-8-61-T-13-reverse.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2019\/09\/Headstone-Calvary-8-61-T-13-reverse.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2019\/09\/Headstone-Calvary-8-61-T-13-reverse.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":1673,"url":"https:\/\/matthannan.net\/blog\/install-unifi-controller-on-raspberry-pi-in-5-min-step-by-step\/","url_meta":{"origin":636,"position":2},"title":"Install Unifi Controller on Raspberry Pi in 5 Min [Step-By-Step]","author":"matthannan","date":"12 November 2019","format":false,"excerpt":"Quick and easy guide to install the Unifi Controller on a Raspberry Pi. Get it up and running in 5 minutes. - Updated April 2019 -Source: Install Unifi Controller on Raspberry Pi in 5 Min [Step-By-Step] UniPi? Ramping things up for the great migration from Verizon FiOS. Ethernet is run\u2026","rel":"","context":"In &quot;Geek&quot;","block_context":{"text":"Geek","link":"https:\/\/matthannan.net\/blog\/category\/geek\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1069,"url":"https:\/\/matthannan.net\/blog\/zork-2017\/","url_meta":{"origin":636,"position":3},"title":"Zork 2017","author":"matthannan","date":"23 April 2017","format":false,"excerpt":"I am working my way through Zed Shaw's \"Learn Python the Hard Way\", which is both a book with a DVD containing videos of each of the lessons and a web site that does not have the videos. So far, I am really enjoying it. I'm on lesson 36 and\u2026","rel":"","context":"In &quot;Geek&quot;","block_context":{"text":"Geek","link":"https:\/\/matthannan.net\/blog\/category\/geek\/"},"img":{"alt_text":"Calin's game map","src":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2017\/04\/CalinDesignsGameForDaddy-237x300.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":813,"url":"https:\/\/matthannan.net\/blog\/a-visit-to-glasnevin-cemetery\/","url_meta":{"origin":636,"position":4},"title":"A visit to Glasnevin Cemetery","author":"matthannan","date":"31 March 2016","format":false,"excerpt":"A few days after visiting all the places my Hannon clan lived, it was time to meet them at their final address: Glasnevin Cemetery. Last year, I was fortunate enough to have a photo request picked up by an amazing volunteer at Find-A-Grave. He did an A+ job and even\u2026","rel":"","context":"In &quot;Genealogy&quot;","block_context":{"text":"Genealogy","link":"https:\/\/matthannan.net\/blog\/category\/genealogy\/"},"img":{"alt_text":"Glasnevin map","src":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2016\/03\/glasnevin_map-1024x737.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2016\/03\/glasnevin_map-1024x737.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2016\/03\/glasnevin_map-1024x737.png?resize=525%2C300 1.5x"},"classes":[]},{"id":6,"url":"https:\/\/matthannan.net\/blog\/hello-world-2\/","url_meta":{"origin":636,"position":5},"title":"Hello, world!","author":"matthannan","date":"20 February 2009","format":false,"excerpt":"Test post","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/posts\/636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/comments?post=636"}],"version-history":[{"count":1,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/posts\/636\/revisions"}],"predecessor-version":[{"id":638,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/posts\/636\/revisions\/638"}],"wp:attachment":[{"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/media?parent=636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/categories?post=636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/tags?post=636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}