{"id":2208,"date":"2011-02-02T10:51:58","date_gmt":"2011-02-02T10:51:58","guid":{"rendered":"https:\/\/www.financial-fluency.co.uk\/"},"modified":"2020-03-19T18:48:15","modified_gmt":"2020-03-19T18:48:15","slug":"index-and-match-excel-spreadsheet-function","status":"publish","type":"page","link":"https:\/\/www.financial-fluency.co.uk\/financial-training-courses\/business-it-skills\/spreadsheet-excel-skills\/index-and-match-excel-spreadsheet-function\/","title":{"rendered":"Index and Match Excel Spreadsheet Function"},"content":{"rendered":"<p>The Index and Match spreadsheet function in Excel is a useful replacement for vlookup. Nesting Index &#038; Match into one formula can overcome some of the issues of vlookup, such as looking &#8216;left&#8217; and calculating and\/or updating column numbers. <\/p>\n<p>This video gives a very brief overview of how to use index &#038; match and the differences to vlookup. <\/p>\n<p><iframe loading=\"lazy\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/XIWUtfmCd2A?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Index and Match spreadsheet function in Excel is a useful replacement for vlookup. Nesting Index &#038; Match into one formula can overcome some of the issues of vlookup, such as looking &#8216;left&#8217; and calculating and\/or updating column numbers. This video gives a very brief overview of how to use index &#038; match and the [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"parent":89,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/2208"}],"collection":[{"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/comments?post=2208"}],"version-history":[{"count":16,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/2208\/revisions"}],"predecessor-version":[{"id":2219,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/2208\/revisions\/2219"}],"up":[{"embeddable":true,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/89"}],"wp:attachment":[{"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/media?parent=2208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}