{"id":10843,"date":"2016-11-22T05:55:30","date_gmt":"2016-11-22T05:55:30","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=10843"},"modified":"2016-11-22T05:55:30","modified_gmt":"2016-11-22T05:55:30","slug":"excel-heaven-tutorial-05-anatomy-of-the-indexmatch-formula","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/excel-heaven-tutorial-05-anatomy-of-the-indexmatch-formula\/","title":{"rendered":"[Excel-Heaven Tutorial 05] Anatomy of the Index\/Match Formula"},"content":{"rendered":"

Finally, my Excel Visual Basic Automation Tutorial Videos are back with audible audio!<\/em><\/p>\n

For 2 weeks I battled audio recording problems in creating video tutorials. First it was that NO audio was recorded at all. Later, VERY low audio was\u00a0picked up by the headset mic I was using.<\/p>\n

My usual relentless approach to dealing with problems kept me going at it, until I found a way. So here's Tutorial 05...!<\/p>\n

The screenshot below shows the user interface I created to explain how I constructed the INDEX\/MATCH formula used in the ExcelVB Automation\u00a0Tutorial 04<\/a>.<\/strong><\/p>\n

\"The<\/a><\/strong><\/p>\n

All my Excel Heaven Visual Basic Automation club<\/a> members got a compressed zipped folder containing the video tutorial along with the MS Excel Tutorial Workbook in their emails.<\/em><\/p>\n

Excerpts:<\/strong><\/p>\n

1. In-cell drop down menu for choosing \"Item Name\" from the table. I use it here to enable easy comparison of the behaviour of the functions in 2, 3, and 4.<\/p>\n

2. The syntax for the INDEX function shown below the result it gives<\/p>\n

3. The syntax for the MATCH function shown below the result it gives<\/p>\n

4. The syntax for the INDEX\/MATCH formula shown below the result it gives via combination of the INDEX and MATCH functions.<\/p><\/blockquote>\n

****Full explanation in the screenshot step-by-step video tutorial emailed to you, along with this workbook (click here<\/a> to request a copy).****<\/strong><\/p>\n

Quick Tip:<\/strong> In Windows 7 and above, you can watch the video using the VLC player simply by double clicking on the FLV video file (the largest of 3 filed) that you will find AFTER you unzip the compressed zipped folder emailed to you.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Finally, my Excel Visual Basic Automation Tutorial Videos are back with audible audio! For 2 weeks I battled audio recording problems in creating video tutorials. First it was that NO audio was recorded at all. Later, VERY low audio was\u00a0picked up by the headset mic I was using. My usual relentless approach to dealing with […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8,1375,266,10],"tags":[2570,2569],"class_list":["post-10843","post","type-post","status-publish","format-standard","hentry","category-employeescareer-persons","category-entrepreneurs","category-excel-vb-solutions","category-my-dn-travel-news","category-self-development","tag-anatomy-of-the-indexmatch-formula","tag-excel-heaven-tutorial-05"],"aioseo_notices":[],"views":1279,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=10843"}],"version-history":[{"count":3,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10843\/revisions"}],"predecessor-version":[{"id":10847,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10843\/revisions\/10847"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=10843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=10843"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=10843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}