title

XLOOKUP in Excel | Excel Tutorials for Beginners

description

Take my Full Excel for Data Analytics Course! https://www.analystbuilder.com/courses/excel-for-data-analytics
Excel is one of the most used skills in the data world. In this series we will be walking through all of the most important topics that Data Analysts need to know in order to be proficient in Excel.
Excel XLOOKUP Template: https://bit.ly/314BWFV
Microsoft XLOOKUP Documentation: https://bit.ly/3mF3dGx
Udemy Excel Courses:
Pivot Tables in Excel: https://bit.ly/3peELgG
Visualizations and Charts in Excel: https://bit.ly/30MU9HT
All Excel Essentials: https://bit.ly/3Fdk6iG
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
Tableau A-Z - http://bit.ly/385lYvN
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
Patreon Page - https://www.patreon.com/AlexTheAnalyst
Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop
____________________________________________
Websites:
GitHub: https://github.com/AlexTheAnalyst
Instagram: @Alex_The_Analyst
____________________________________________
0:00 Intro
0:59 XLOOKUP Overview
4:14 XLOOKUP w Multiple Rows
6:16 XLOOKUP Exact Match
9:29 XLOOKUP Search Order
12:12 XLOOKUP Horizontal Search
12:55 XLOOKUP w SUM()
14:51 XLOOKUP vs VLOOKUP
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

detail

{'title': 'XLOOKUP in Excel | Excel Tutorials for Beginners', 'heatmap': [{'end': 771.153, 'start': 742.799, 'weight': 0.818}], 'summary': 'Excel tutorial introduces xlookup as superior to vlookup, covering match modes, text searching, and demonstrating its usage with multiple examples, promoting udemy for excel courses, and showcasing its advantage in automating processes and calculations.', 'chapters': [{'end': 448.955, 'segs': [{'end': 53.315, 'src': 'embed', 'start': 0.229, 'weight': 0, 'content': [{'end': 2.433, 'text': "What's going on, everybody? Welcome back to another video.", 'start': 0.229, 'duration': 2.204}, {'end': 4.897, 'text': "In this Excel tutorial, we'll be looking at XLOOKUP.", 'start': 2.633, 'duration': 2.264}, {'end': 18.435, 'text': "Now, if you don't already know what XLOOKUP is, it is a new feature in Excel to kind of replace VLOOKUP or, to be a much better option,", 'start': 11.069, 'duration': 7.366}, {'end': 21.298, 'text': 'at least in my mind, is a much better option than VLOOKUP.', 'start': 18.435, 'duration': 2.863}, {'end': 28.284, 'text': "And so, if you're someone who's either used VLOOKUP a lot and you're trying to learn this new option, or if you've never used it before,", 'start': 21.718, 'duration': 6.566}, {'end': 32.808, 'text': "this video will be super helpful because I'll walk you through kind of the options and what XLOOKUP can do,", 'start': 28.284, 'duration': 4.524}, {'end': 35.31, 'text': 'as well as the difference between XLOOKUP and VLOOKUP.', 'start': 32.808, 'duration': 2.502}, {'end': 39.391, 'text': "But before we get into the tutorial, I want to give a huge shout out to today's sponsor, and that is Udemy.", 'start': 35.43, 'duration': 3.961}, {'end': 42.832, 'text': 'Udemy is the go-to place if you want a full-fledged course in Excel.', 'start': 39.731, 'duration': 3.101}, {'end': 47.853, 'text': "I have three options of courses that I have taken on Udemy, so I'd highly recommend checking those out.", 'start': 43.192, 'duration': 4.661}, {'end': 53.315, 'text': 'They are having a huge sale on all their courses during this time, and so if you are in the market for a course,', 'start': 48.113, 'duration': 5.202}], 'summary': 'Excel tutorial on xlookup, a better option than vlookup, sponsored by udemy.', 'duration': 53.086, 'max_score': 0.229, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s229.jpg'}, {'end': 205.679, 'src': 'embed', 'start': 175.023, 'weight': 2, 'content': [{'end': 177.405, 'text': "So here's Toby Flenderson, here's Toby Flenderson.", 'start': 175.023, 'duration': 2.382}, {'end': 180.126, 'text': 'So it will find it in this array right here.', 'start': 177.445, 'duration': 2.681}, {'end': 187.727, 'text': "then we're gonna hit comma, and now we need to give it the return array, what it's going to return on that row when it finds it.", 'start': 181.323, 'duration': 6.404}, {'end': 189.729, 'text': "So we're gonna return his email.", 'start': 188.288, 'duration': 1.441}, {'end': 191.149, 'text': 'Keep it really simple.', 'start': 190.109, 'duration': 1.04}, {'end': 194.191, 'text': "So what it should do, and let's close the parentheses.", 'start': 191.67, 'duration': 2.521}, {'end': 197.133, 'text': 'what it should do is it should take Toby Flenderson,', 'start': 194.191, 'duration': 2.942}, {'end': 205.679, 'text': "it's going to search in this column or in this array and then it's going to return the email when it finds toby flenderson.", 'start': 197.133, 'duration': 8.546}], 'summary': 'The function will search for toby flenderson in an array and return his email.', 'duration': 30.656, 'max_score': 175.023, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s175023.jpg'}, {'end': 272.037, 'src': 'embed', 'start': 244.326, 'weight': 4, 'content': [{'end': 248.592, 'text': "But just know that if you're using XLOOKUP for the first time, you're just getting into using Excel.", 'start': 244.326, 'duration': 4.266}, {'end': 249.873, 'text': 'You guys have it good.', 'start': 248.932, 'duration': 0.941}, {'end': 251.716, 'text': 'OK, so just know that.', 'start': 250.414, 'duration': 1.302}, {'end': 263.771, 'text': "Now let's go over here to XLOOKUP multiple rows because you can return more than one output with with XLOOKUP.", 'start': 252.977, 'duration': 10.794}, {'end': 270.035, 'text': "So let's go right in here and we're gonna basically write the exact same thing as we did before.", 'start': 264.371, 'duration': 5.664}, {'end': 272.037, 'text': "So let's write XLOOKUP.", 'start': 270.576, 'duration': 1.461}], 'summary': 'Xlookup allows returning multiple outputs in excel.', 'duration': 27.711, 'max_score': 244.326, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s244326.jpg'}], 'start': 0.229, 'title': 'Excel xlookup and vlookup differences', 'summary': 'Introduces xlookup as a superior option to vlookup, highlighting its features, advantages, and demonstrating its functionalities with multiple examples, and promoting udemy for excel courses.', 'chapters': [{'end': 70.726, 'start': 0.229, 'title': 'Excel xlookup tutorial', 'summary': 'Introduces xlookup as a superior option to vlookup in excel, explaining its features and differences and promoting udemy for excel courses.', 'duration': 70.497, 'highlights': ['The chapter introduces XLOOKUP as a much better option than VLOOKUP in Excel, providing a detailed comparison and explanation of its features.', 'The chapter promotes Udemy for Excel courses, highlighting a huge sale on all their courses during this time and recommending it for those in the market for a course.', "The chapter emphasizes the video's helpfulness for both experienced VLOOKUP users and beginners, promising to walk through XLOOKUP's options and capabilities."]}, {'end': 448.955, 'start': 70.726, 'title': 'Difference between vlookup and xlookup', 'summary': 'Introduces xlookup formula, explaining its features and usage, demonstrating how to use it with lookup value, lookup array, and return array, and highlighting the advantages over vlookup, and showcasing multiple rows and exact match functionalities.', 'duration': 378.229, 'highlights': ['It explains the features and usage of the XLOOKUP formula, including its ability to search a range or an array for a match and return the corresponding item, with an exact match by default. The XLOOKUP formula is explained, highlighting its ability to search a range or an array for a match and return the corresponding item, with an exact match by default.', 'It demonstrates how to use XLOOKUP with a lookup value, lookup array, and return array, using Toby Flenderson as the lookup value and returning his email. A demonstration of using XLOOKUP with a lookup value, lookup array, and return array is provided, using Toby Flenderson as the lookup value and returning his email.', 'It highlights the advantages of XLOOKUP over VLOOKUP, emphasizing that it is less complicated and more user-friendly for those new to using Excel. The advantages of XLOOKUP over VLOOKUP are highlighted, emphasizing that XLOOKUP is less complicated and more user-friendly for those new to using Excel.', 'It showcases the functionality of XLOOKUP for returning multiple rows, allowing users to include multiple output columns for a single lookup value. The functionality of XLOOKUP for returning multiple rows is showcased, allowing users to include multiple output columns for a single lookup value.', "It demonstrates the exact match functionality of XLOOKUP, including the ability to handle 'not found' scenarios and customize the output. The exact match functionality of XLOOKUP is demonstrated, including its ability to handle 'not found' scenarios and customize the output."]}], 'duration': 448.726, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s229.jpg', 'highlights': ['The chapter introduces XLOOKUP as a much better option than VLOOKUP in Excel, providing a detailed comparison and explanation of its features.', 'It explains the features and usage of the XLOOKUP formula, including its ability to search a range or an array for a match and return the corresponding item, with an exact match by default.', 'It demonstrates how to use XLOOKUP with a lookup value, lookup array, and return array, using Toby Flenderson as the lookup value and returning his email.', 'It highlights the advantages of XLOOKUP over VLOOKUP, emphasizing that it is less complicated and more user-friendly for those new to using Excel.', 'It showcases the functionality of XLOOKUP for returning multiple rows, allowing users to include multiple output columns for a single lookup value.', 'The chapter promotes Udemy for Excel courses, highlighting a huge sale on all their courses during this time and recommending it for those in the market for a course.']}, {'end': 775.656, 'segs': [{'end': 475.553, 'src': 'embed', 'start': 448.975, 'weight': 0, 'content': [{'end': 452.898, 'text': "We're actually just going to copy this because I want to reuse it.", 'start': 448.975, 'duration': 3.923}, {'end': 455.519, 'text': "And then we're going to go right here.", 'start': 454.178, 'duration': 1.341}, {'end': 456.54, 'text': "I'm going to hit a comma.", 'start': 455.539, 'duration': 1.001}, {'end': 458.721, 'text': 'Now, this is our match mode option.', 'start': 457.16, 'duration': 1.561}, {'end': 462.204, 'text': 'And so we have four different options that we can choose from.', 'start': 459.762, 'duration': 2.442}, {'end': 463.525, 'text': 'A 0 is an exact match.', 'start': 462.224, 'duration': 1.301}, {'end': 467.948, 'text': 'And that is, by default, that is what we have or what we use.', 'start': 463.745, 'duration': 4.203}, {'end': 469.649, 'text': "Then there's a minus 1.", 'start': 468.468, 'duration': 1.181}, {'end': 471.73, 'text': "That's an exact match or next smaller item.", 'start': 469.649, 'duration': 2.081}, {'end': 475.553, 'text': "Then there's a 1, which is an exact match or next larger item.", 'start': 472.271, 'duration': 3.282}], 'summary': 'Options for match mode include exact match, next smaller item, and next larger item.', 'duration': 26.578, 'max_score': 448.975, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s448975.jpg'}, {'end': 518.116, 'src': 'embed', 'start': 490.883, 'weight': 2, 'content': [{'end': 497.127, 'text': "but if there's not a wild card option already put in here, it doesn't recognize it.", 'start': 490.883, 'duration': 6.244}, {'end': 500.049, 'text': 'so we need to indicate where that wild card needs to be.', 'start': 497.127, 'duration': 2.922}, {'end': 503.467, 'text': "So we're going to do a double apostrophe or quotation marks.", 'start': 500.845, 'duration': 2.622}, {'end': 506.429, 'text': "We're going to put an asterisk right here and then do another one.", 'start': 503.487, 'duration': 2.942}, {'end': 509.351, 'text': "And we're going to hit an ampersand.", 'start': 506.929, 'duration': 2.422}, {'end': 510.872, 'text': "So we're going to have an ampersand right here.", 'start': 509.371, 'duration': 1.501}, {'end': 518.116, 'text': "And what that's going to say is anything that comes before A4, anything that comes before Beasley is okay.", 'start': 511.472, 'duration': 6.644}], 'summary': 'Instructions for using wild card in a query: use double apostrophes or quotation marks, asterisk, and ampersand to indicate wild card placement.', 'duration': 27.233, 'max_score': 490.883, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s490883.jpg'}, {'end': 595.24, 'src': 'embed', 'start': 569.603, 'weight': 1, 'content': [{'end': 575.244, 'text': "Now, I know I said we were looking at search order, but I'm actually going to kind of give you an exact match first and then search order,", 'start': 569.603, 'duration': 5.641}, {'end': 577.005, 'text': "but it's just kind of easier to show it over here.", 'start': 575.244, 'duration': 1.761}, {'end': 580.091, 'text': "So I'm going to do XLOOKUP.", 'start': 577.93, 'duration': 2.161}, {'end': 581.572, 'text': "I'm going to look up this value.", 'start': 580.111, 'duration': 1.461}, {'end': 583.093, 'text': 'Do a comma.', 'start': 582.433, 'duration': 0.66}, {'end': 584.294, 'text': "Here's the range.", 'start': 583.453, 'duration': 0.841}, {'end': 586.415, 'text': "This is our start date that it's going to be looking for.", 'start': 584.334, 'duration': 2.081}, {'end': 588.736, 'text': 'And I want to return the full name.', 'start': 587.256, 'duration': 1.48}, {'end': 595.24, 'text': 'Now, no value in here has 112000.', 'start': 589.517, 'duration': 5.723}], 'summary': 'Demonstration of xlookup with specific value and criteria.', 'duration': 25.637, 'max_score': 569.603, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s569603.jpg'}, {'end': 676.415, 'src': 'embed', 'start': 645.779, 'weight': 3, 'content': [{'end': 647.82, 'text': "Now let's get over to search mode.", 'start': 645.779, 'duration': 2.041}, {'end': 651.321, 'text': 'Now the search mode performs a search starting at the first item.', 'start': 647.88, 'duration': 3.441}, {'end': 653.282, 'text': 'So at the very top going down.', 'start': 651.421, 'duration': 1.861}, {'end': 661.566, 'text': 'So, by default it searches from first to last, but you can reverse that and do search from last to first, or you can do a binary search,', 'start': 653.622, 'duration': 7.944}, {'end': 665.348, 'text': 'which is where it sorts in ascending order or sorts in descending order.', 'start': 661.566, 'duration': 3.782}, {'end': 668.209, 'text': "And that's with the actual value.", 'start': 666.548, 'duration': 1.661}, {'end': 676.415, 'text': "And so we won't be able to show this binary search ascending or descending because our values are the same.", 'start': 668.59, 'duration': 7.825}], 'summary': 'The search mode can perform searches in various directions and supports binary search with ascending or descending order.', 'duration': 30.636, 'max_score': 645.779, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s645779.jpg'}, {'end': 771.153, 'src': 'heatmap', 'start': 742.799, 'weight': 0.818, 'content': [{'end': 744.519, 'text': "Let's say equals XLOOKUP.", 'start': 742.799, 'duration': 1.72}, {'end': 747.34, 'text': 'The value that we want to be searching for is February.', 'start': 745.199, 'duration': 2.141}, {'end': 748.2, 'text': "That's what we're looking for.", 'start': 747.38, 'duration': 0.82}, {'end': 749.14, 'text': 'Hit comma.', 'start': 748.22, 'duration': 0.92}, {'end': 754.501, 'text': 'And where do we want to search to find February? We want to search in these calendar months.', 'start': 749.6, 'duration': 4.901}, {'end': 758.162, 'text': "And then we hit another comma, and now we're going to be searching for paper.", 'start': 755.301, 'duration': 2.861}, {'end': 766.93, 'text': "So let's do paper and we'll hit enter and it found February and it returned paper right here.", 'start': 759.326, 'duration': 7.604}, {'end': 771.153, 'text': 'And we can do that for paper printer and Manila folders.', 'start': 767.451, 'duration': 3.702}], 'summary': 'Using xlookup, search for february in calendar months to find paper, printer, and manila folders.', 'duration': 28.354, 'max_score': 742.799, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s742799.jpg'}], 'start': 448.975, 'title': 'Match modes and xlookup', 'summary': 'Covers the concept of match modes in text searching, including exact match, next smaller item, next larger item, and wild card character match, with examples. it also explains the usage of xlookup function for exact match and search order, introducing xlookuphorizontal and xlookupwithsum functions.', 'chapters': [{'end': 569.223, 'start': 448.975, 'title': 'Using match modes for text searching', 'summary': 'Explains the concept of match modes in text searching, including the options of exact match, next smaller item, next larger item, and wild card character match, with examples demonstrating the use of wild card characters to retrieve specific outputs.', 'duration': 120.248, 'highlights': ['The chapter introduces four match mode options, including exact match (0), next smaller item (-1), next larger item (1), and wild card character match (2).', 'The explanation provides an example of using wild card characters, such as double apostrophe, asterisk, and ampersand, to retrieve specific outputs based on the desired text patterns.', 'The demonstration showcases the practical application of wild card characters to ensure that any text preceding a specified pattern is acceptable, enabling the retrieval of desired outputs.']}, {'end': 775.656, 'start': 569.603, 'title': 'Xlookup and search order explained', 'summary': 'Explains the usage of xlookup function to perform exact match and search order, showcasing how to return values based on different match modes and search directions, and introducing xlookuphorizontal and xlookupwithsum functions.', 'duration': 206.053, 'highlights': ['XLOOKUP function used to perform exact match and next larger value search Demonstrates the usage of XLOOKUP to return values based on exact match or next larger value, using an example with start dates and full names.', 'Explanation of search modes including first to last, last to first, and binary search Explains the search modes in XLOOKUP, showcasing searching from first to last, last to first, and binary search, with examples and returned values.', 'Introduction to XLOOKUPHORIZONTAL and XLOOKUPWITHSUM functions Introduces XLOOKUPHORIZONTAL and XLOOKUPWITHSUM functions, demonstrating the usage to search for specific values and return corresponding results.']}], 'duration': 326.681, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s448975.jpg', 'highlights': ['The chapter introduces four match mode options, including exact match (0), next smaller item (-1), next larger item (1), and wild card character match (2).', 'XLOOKUP function used to perform exact match and next larger value search Demonstrates the usage of XLOOKUP to return values based on exact match or next larger value, using an example with start dates and full names.', 'The explanation provides an example of using wild card characters, such as double apostrophe, asterisk, and ampersand, to retrieve specific outputs based on the desired text patterns.', 'Explanation of search modes including first to last, last to first, and binary search Explains the search modes in XLOOKUP, showcasing searching from first to last, last to first, and binary search, with examples and returned values.']}, {'end': 1113.855, 'segs': [{'end': 828.726, 'src': 'embed', 'start': 798.246, 'weight': 0, 'content': [{'end': 807.571, 'text': "Now you're going to be using the formula sum, and so we're going to do sum and then, within the sum,", 'start': 798.246, 'duration': 9.325}, {'end': 812.894, 'text': 'our first number is going to be an XLOOKUP and then our next value is also going to be an XLOOKUP.', 'start': 807.571, 'duration': 5.323}, {'end': 819.578, 'text': "So let's do XLOOKUP, and now we're going to search for our very first value.", 'start': 813.534, 'duration': 6.044}, {'end': 821.919, 'text': 'Oops, our very first lookup value.', 'start': 819.778, 'duration': 2.141}, {'end': 828.726, 'text': "So we're going to go to And then we're going to search this again.", 'start': 822.219, 'duration': 6.507}], 'summary': 'Using xlookup formula to sum values in a spreadsheet.', 'duration': 30.48, 'max_score': 798.246, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s798246.jpg'}, {'end': 906.835, 'src': 'embed', 'start': 860.014, 'weight': 1, 'content': [{'end': 864.237, 'text': 'So now we are basically adding this February and this March.', 'start': 860.014, 'duration': 4.223}, {'end': 866.438, 'text': "So it's gonna be 310 plus 150.", 'start': 864.417, 'duration': 2.021}, {'end': 871.881, 'text': "It's adding those two values and it should be, what, 460.", 'start': 866.438, 'duration': 5.443}, {'end': 873.742, 'text': "So let's see if that is our output.", 'start': 871.881, 'duration': 1.861}, {'end': 875.443, 'text': 'And it is.', 'start': 874.703, 'duration': 0.74}, {'end': 878.485, 'text': 'So you can do this with a lot of things, not just some,', 'start': 875.583, 'duration': 2.902}, {'end': 886.87, 'text': "but you're able to use XLOOKUP within different formulas if you're searching for a specific value and a specific value in another cell.", 'start': 878.485, 'duration': 8.385}, {'end': 891.832, 'text': "you can add those together using XLOOKUP, which is honestly, it's pretty great.", 'start': 887.35, 'duration': 4.482}, {'end': 893.872, 'text': "So let's go over to VLOOKUP.", 'start': 892.132, 'duration': 1.74}, {'end': 902.915, 'text': 'So I wanted to show you this because I wanted to show you where it came from and what we used to do unless you are continuing to use VLOOKUP and what we can do now.', 'start': 894.052, 'duration': 8.863}, {'end': 904.956, 'text': 'So XLOOKUP, I just showed you kind of everything.', 'start': 902.995, 'duration': 1.961}, {'end': 906.835, 'text': 'But super quickly.', 'start': 906.034, 'duration': 0.801}], 'summary': 'Using xlookup and vlookup, 310 plus 150 equals 460, showcasing their versatility and efficiency in different formulas.', 'duration': 46.821, 'max_score': 860.014, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s860014.jpg'}], 'start': 775.916, 'title': 'Using xlookup and vlookup in excel', 'summary': 'Demonstrates using xlookup with sum to retrieve and sum multiple values, adding february and march values to get 460, and explains the advantages of xlookup over vlookup, making it easier to automate processes and create calculations in excel.', 'chapters': [{'end': 859.086, 'start': 775.916, 'title': 'Using sum with xlookup', 'summary': 'Demonstrates how to use the formula sum with xlookup to retrieve and sum multiple values, showcasing the process step by step.', 'duration': 83.17, 'highlights': ['The demonstration illustrates the process of using the formula sum with XLOOKUP to retrieve and sum multiple values.', "The speaker shows how to use XLOOKUP to search for specific values, such as 'March', within the data range.", 'The tutorial emphasizes the step-by-step process of utilizing XLOOKUP and sum to manipulate and retrieve data efficiently.']}, {'end': 984.317, 'start': 860.014, 'title': 'Using xlookup and vlookup in formulas', 'summary': 'Demonstrates the use of xlookup in adding february and march values to get 460, along with the difference between vlookup and xlookup in searching for specific values.', 'duration': 124.303, 'highlights': ['The chapter demonstrates adding February and March values using XLOOKUP to obtain 460, showcasing the practical applicability of the function.', 'It explains the differences between VLOOKUP and XLOOKUP, offering insights into their functionality and usage in searching for specific values in a table array.', 'The speaker illustrates the process of using VLOOKUP, highlighting the steps involved in specifying the lookup value, table array, column index number, and range lookup for finding a specific value in a dataset.']}, {'end': 1113.855, 'start': 984.497, 'title': 'Xlookup vs vlookup in excel', 'summary': 'Explains the advantages of xlookup over vlookup in excel, highlighting how xlookup automatically adjusts when new data is added, while vlookup requires manual updates, making it easier to automate processes and create calculations in excel.', 'duration': 129.358, 'highlights': ['XLOOKUP automatically adjusts when new data is added, while VLOOKUP requires manual updates, making it easier to automate processes and create calculations in Excel.', 'VLOOKUP requires manual updating when data is changed or new columns are added, while XLOOKUP automatically adjusts to the changes, saving time and effort.', 'XLOOKUP makes it easier to automate processes and create calculations in Excel, as it automatically adjusts to changes in the data, while VLOOKUP requires manual updates.']}], 'duration': 337.939, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z7hPEwCzk2s/pics/Z7hPEwCzk2s775916.jpg', 'highlights': ['The demonstration illustrates the process of using the formula sum with XLOOKUP to retrieve and sum multiple values.', 'The chapter demonstrates adding February and March values using XLOOKUP to obtain 460, showcasing the practical applicability of the function.', 'XLOOKUP automatically adjusts when new data is added, while VLOOKUP requires manual updates, making it easier to automate processes and create calculations in Excel.']}], 'highlights': ['XLOOKUP is introduced as a superior option to VLOOKUP in Excel, with a detailed comparison and explanation of its features.', 'XLOOKUP formula can search a range or an array for a match and return the corresponding item, with an exact match by default.', "Demonstration of using XLOOKUP with a lookup value, lookup array, and return array, returning Toby Flenderson's email.", 'Advantages of XLOOKUP over VLOOKUP are highlighted, emphasizing its user-friendliness for Excel beginners.', 'Showcasing the functionality of XLOOKUP for returning multiple rows and including multiple output columns for a single lookup value.', 'Promotion of Udemy for Excel courses, highlighting a huge sale on all their courses and recommending it for those in the market for a course.', 'Introduction of four match mode options for XLOOKUP, including exact match, next smaller item, next larger item, and wild card character match.', 'Demonstration of using XLOOKUP to return values based on exact match or next larger value, using an example with start dates and full names.', 'Explanation of using wild card characters to retrieve specific outputs based on desired text patterns.', 'Explanation of search modes in XLOOKUP, showcasing searching from first to last, last to first, and binary search, with examples and returned values.', 'Illustration of using the formula sum with XLOOKUP to retrieve and sum multiple values.', 'Demonstration of adding February and March values using XLOOKUP to obtain 460, showcasing the practical applicability of the function.', "Highlighting XLOOKUP's automatic adjustment when new data is added, making it easier to automate processes and create calculations in Excel."]}