{"id":23,"date":"2026-02-18T13:05:06","date_gmt":"2026-02-18T18:05:06","guid":{"rendered":"https:\/\/community.mis.temple.edu\/calvinbinu\/blog\/points\/mastering-lookup-functions-in-excel-seven-powerful-formulas\/"},"modified":"2026-02-18T13:05:06","modified_gmt":"2026-02-18T18:05:06","slug":"mastering-lookup-functions-in-excel-seven-powerful-formulas","status":"publish","type":"points","link":"https:\/\/community.mis.temple.edu\/calvinbinu\/points\/mastering-lookup-functions-in-excel-seven-powerful-formulas\/","title":{"rendered":"Mastering Lookup Functions in Excel: Seven Powerful Formulas"},"content":{"rendered":"<p>I completed the LinkedIn Learning course Mastering Lookup Functions in Excel: Seven Powerful Formulas to strengthen my Excel and data analysis skills. In this course, I learned how to use VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, INDEX-MATCH, and GETPIVOTDATA to efficiently retrieve and analyze data from large datasets. I gained a better understanding of how lookup functions work, especially how combining INDEX and MATCH or using XLOOKUP creates more flexible and dynamic spreadsheets. As a Management Information Systems major, these skills are directly applicable to my coursework and future career, where working with data accurately and efficiently is essential for business decision-making.<\/p>\n","protected":false},"author":31437,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-23","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/calvinbinu\/wp-json\/wp\/v2\/points\/23","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/calvinbinu\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/calvinbinu\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/calvinbinu\/wp-json\/wp\/v2\/users\/31437"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/calvinbinu\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":0,"href":"https:\/\/community.mis.temple.edu\/calvinbinu\/wp-json\/wp\/v2\/points\/23\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/calvinbinu\/wp-json\/wp\/v2\/media?parent=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}