title
XLOOKUP in Excel Tutorial

description
In this step-by-step beginner's tutorial, learn how to use the XLOOKUP function in Microsoft Excel. With Excel XLOOKUP formula, you can look up values on the same worksheet or between multiple worksheets. For example, let's say I have a cookie name, chocolate chip, my favorite, and I want to know the price. I have another table with the prices. I can look up the cookie name and get the price back. We'll look at how this function works in the simplest form and then we'll look at more advanced capabilities. XLOOKUP is currently available to Microsoft 365 subscribes. If you don't have Microsoft 365, you can use VLOOKUP or HLOOKUP. 👋 Additional resources - Sample spreadsheet to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whM4IxMRV87IJqXHing?e=9xO0Z7 - How to use VLOOKUP in Excel - Complete Tutorial: https://youtu.be/DZEPA9UhLBw - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 1:13 Basic example of XLOOKUP 4:20 Show text when value is not found 5:11 Horizontal lists 5:45 Across worksheets 6:32 Return multiple items 7:29 Nest within other functions 8:58 Use multiple criteria 10:10 Match modes 11:59 Search modes 13:02 Nested XLOOKUP for grid view lookup 15:59 Wrap up 📃 Watch related playlists - Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 Connect with me on social - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert

detail
{'title': 'XLOOKUP in Excel Tutorial', 'heatmap': [{'end': 211.202, 'start': 158.846, 'weight': 0.771}, {'end': 456.344, 'start': 426.061, 'weight': 0.747}, {'end': 610.384, 'start': 588.784, 'weight': 0.778}, {'end': 872.022, 'start': 848.485, 'weight': 0.705}], 'summary': 'The tutorial covers the use of xlookup function in excel, demonstrating its basic example, availability for microsoft 365 subscribers, and its efficiency in finding the price of a chocolate chip cookie, showcasing various functionalities including vertical and horizontal lookup, searching across multiple worksheets, returning multiple values, nesting within other functions, and looking up based on multiple criteria, as well as exploring its optional parameters for customized searches and demonstrating nesting xlookup for efficient data retrieval with automatic updates.', 'chapters': [{'end': 80.187, 'segs': [{'end': 27.253, 'src': 'embed', 'start': 0.129, 'weight': 0, 'content': [{'end': 13.782, 'text': 'Today I want to show you how you can use the XLOOKUP function in Microsoft Excel, and just like the name implies, with XLOOKUP you can look up values.', 'start': 0.129, 'duration': 13.653}, {'end': 17.666, 'text': "For example, let's say I have a chocolate chip cookie.", 'start': 14.523, 'duration': 3.143}, {'end': 23.551, 'text': "That's my favorite type of cookie, and I want to know how much does this cookie cost.", 'start': 18.046, 'duration': 5.505}, {'end': 27.253, 'text': 'I have a table with all of the different cookie prices.', 'start': 24.332, 'duration': 2.921}], 'summary': 'Demonstrate using xlookup function in excel to look up values.', 'duration': 27.124, 'max_score': 0.129, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA129.jpg'}, {'end': 80.187, 'src': 'embed', 'start': 52.259, 'weight': 1, 'content': [{'end': 55.78, 'text': "and then we'll go and look at some of the more advanced capabilities.", 'start': 52.259, 'duration': 3.521}, {'end': 61.701, 'text': 'XLOOKUP is currently only available for Microsoft 365 subscribers.', 'start': 57.02, 'duration': 4.681}, {'end': 69.682, 'text': "If you don't have that, I've also included a video right up above that'll show you how you can use VLOOKUP and HLOOKUP.", 'start': 62.241, 'duration': 7.441}, {'end': 73.323, 'text': "All right, let's check out the XLOOKUP function.", 'start': 70.642, 'duration': 2.681}, {'end': 80.187, 'text': "Let's start with just a basic example that will show you the fundamentals of XLOOKUP.", 'start': 73.942, 'duration': 6.245}], 'summary': 'Xlookup is available for microsoft 365 subscribers. vlookup and hlookup alternatives provided.', 'duration': 27.928, 'max_score': 52.259, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA52259.jpg'}], 'start': 0.129, 'title': 'Using xlookup function in excel', 'summary': 'Demonstrates the use of the xlookup function in microsoft excel, including a basic example and highlights its availability for microsoft 365 subscribers.', 'chapters': [{'end': 80.187, 'start': 0.129, 'title': 'Xlookup function in excel', 'summary': 'Demonstrates the use of the xlookup function in microsoft excel to look up values, showcasing a basic example and mentioning the availability of xlookup for microsoft 365 subscribers.', 'duration': 80.058, 'highlights': ['The XLOOKUP function in Microsoft Excel allows users to look up values, providing a practical example of finding the price of a specific type of cookie in a table.', 'The demonstration includes a basic example showcasing the fundamentals of how XLOOKUP works, with subsequent mention of more advanced capabilities.', 'XLOOKUP is exclusively available for Microsoft 365 subscribers, while alternative methods such as VLOOKUP and HLOOKUP are also provided for non-subscribers.']}], 'duration': 80.058, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA129.jpg', 'highlights': ['The XLOOKUP function in Microsoft Excel allows users to look up values, providing a practical example of finding the price of a specific type of cookie in a table.', 'The demonstration includes a basic example showcasing the fundamentals of how XLOOKUP works, with subsequent mention of more advanced capabilities.', 'XLOOKUP is exclusively available for Microsoft 365 subscribers, while alternative methods such as VLOOKUP and HLOOKUP are also provided for non-subscribers.']}, {'end': 600.235, 'segs': [{'end': 133.934, 'src': 'embed', 'start': 107.828, 'weight': 6, 'content': [{'end': 113.193, 'text': 'So here I wanna look for the cookie name and then I wanna get this price back into this cell.', 'start': 107.828, 'duration': 5.365}, {'end': 124.725, 'text': 'To do that, we are going to use the you guessed it the XLOOKUP function, and by far the easiest way to enter a function is to use the insert function,', 'start': 113.914, 'duration': 10.811}, {'end': 125.065, 'text': 'helper.', 'start': 124.725, 'duration': 0.34}, {'end': 129.128, 'text': "Let's go up to the top left hand corner and click on this icon.", 'start': 125.686, 'duration': 3.442}, {'end': 133.934, 'text': "Within this prompt, let's search for the function XLOOKUP and then click on go.", 'start': 129.59, 'duration': 4.344}], 'summary': 'Using xlookup function to find cookie price and enter into cell.', 'duration': 26.106, 'max_score': 107.828, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA107828.jpg'}, {'end': 211.202, 'src': 'heatmap', 'start': 158.846, 'weight': 0.771, 'content': [{'end': 162.428, 'text': "All right, let's figure out the price for a chocolate chip cookie.", 'start': 158.846, 'duration': 3.582}, {'end': 170.019, 'text': 'Right up on top it asks me for the lookup value and once again I want to know the price of a chocolate chip cookie.', 'start': 163.268, 'duration': 6.751}, {'end': 172.183, 'text': "So this is what we're looking up.", 'start': 170.38, 'duration': 1.803}, {'end': 176.25, 'text': 'Next, it asks me for the lookup array.', 'start': 173.268, 'duration': 2.982}, {'end': 183.777, 'text': "Well, I'm looking for chocolate chip in this table and here I'll select the cookie type column as the lookup array.", 'start': 176.731, 'duration': 7.046}, {'end': 188.56, 'text': 'Once it finds chocolate chip, I want to get the price back.', 'start': 184.837, 'duration': 3.723}, {'end': 191.182, 'text': 'So the return array is the price.', 'start': 189.041, 'duration': 2.141}, {'end': 192.664, 'text': "I'll highlight this column.", 'start': 191.463, 'duration': 1.201}, {'end': 198.528, 'text': "So here once it finds chocolate chip, it'll return this value from that same row.", 'start': 193.184, 'duration': 5.344}, {'end': 205.476, 'text': 'Down below we can see that the price is $5 and once again I filled out all of the required fields.', 'start': 199.449, 'duration': 6.027}, {'end': 211.202, 'text': "I'll click on OK and here again we can see that the price is $5.", 'start': 206.177, 'duration': 5.025}], 'summary': 'The price of a chocolate chip cookie is $5.', 'duration': 52.356, 'max_score': 158.846, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA158846.jpg'}, {'end': 328.783, 'src': 'embed', 'start': 305.003, 'weight': 5, 'content': [{'end': 311.328, 'text': "So when we search for Kevin's Ultimate Special Delicious Cookie, there is unfortunately no such thing.", 'start': 305.003, 'duration': 6.325}, {'end': 318.374, 'text': 'XLOOKUP works great when you have a vertical list of data, but what happens if you have a horizontal list?', 'start': 311.889, 'duration': 6.485}, {'end': 325.48, 'text': 'Here on the next worksheet titled horizontal XLOOKUP works just as well with horizontally presented data.', 'start': 318.815, 'duration': 6.665}, {'end': 328.783, 'text': "Right here again, I'll click into the price field.", 'start': 326.301, 'duration': 2.482}], 'summary': 'Xlookup works for horizontal data in a worksheet titled horizontal xlookup.', 'duration': 23.78, 'max_score': 305.003, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA305003.jpg'}, {'end': 377.9, 'src': 'embed', 'start': 354.268, 'weight': 0, 'content': [{'end': 360.97, 'text': "You've probably already memorized the price of our chocolate chip cookie, but once again, you can also use XLOOKUP across sheets.", 'start': 354.268, 'duration': 6.702}, {'end': 367.952, 'text': "Here once again, I'll open up the function helper, click into XLOOKUP, and here I want to look up chocolate chip.", 'start': 361.79, 'duration': 6.162}, {'end': 372.015, 'text': "For the lookup array, well, there's no table on this sheet.", 'start': 368.732, 'duration': 3.283}, {'end': 377.9, 'text': "Here I'll click into the price table worksheet and here I'll look for chocolate chip in this column.", 'start': 372.535, 'duration': 5.365}], 'summary': 'Demonstrating xlookup function to find chocolate chip price.', 'duration': 23.632, 'max_score': 354.268, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA354268.jpg'}, {'end': 415.839, 'src': 'embed', 'start': 393.212, 'weight': 1, 'content': [{'end': 402.075, 'text': 'One of the nice things about XLOOKUP is not only can you get one value returned, you can have XLOOKUP return multiple values.', 'start': 393.212, 'duration': 8.863}, {'end': 410.997, 'text': 'Here on the return array sheet, not only do I want to look up chocolate chip and get the price back, but I also want to get the cost back.', 'start': 402.575, 'duration': 8.422}, {'end': 413.618, 'text': 'And once again, XLOOKUP can do this.', 'start': 411.377, 'duration': 2.241}, {'end': 415.839, 'text': "Let's click on the function helper.", 'start': 414.318, 'duration': 1.521}], 'summary': 'Xlookup can return multiple values, such as price and cost, for a given item.', 'duration': 22.627, 'max_score': 393.212, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA393212.jpg'}, {'end': 456.344, 'src': 'heatmap', 'start': 426.061, 'weight': 0.747, 'content': [{'end': 432.763, 'text': 'For the return array now, not only do I want to get the price back, but I also want to get the cost back.', 'start': 426.061, 'duration': 6.702}, {'end': 438.145, 'text': "So how do we do that? Well, here I'll simply select both of these columns.", 'start': 433.263, 'duration': 4.882}, {'end': 441.968, 'text': "and now I'll click on OK and look at that.", 'start': 439.085, 'duration': 2.883}, {'end': 449.677, 'text': 'Here it gives me the price per cookie back of $5 and it spills over into this next cell and it also gives me the cost back.', 'start': 442.169, 'duration': 7.508}, {'end': 456.344, 'text': 'When you get multiple values returned, you can nest that within another function.', 'start': 450.298, 'duration': 6.046}], 'summary': 'The function returns price and cost, with a price per cookie of $5.', 'duration': 30.283, 'max_score': 426.061, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA426061.jpg'}, {'end': 555.929, 'src': 'embed', 'start': 529.042, 'weight': 2, 'content': [{'end': 538.852, 'text': "The neat thing here is you can nest your XLOOKUP within other functions and in this case, I'm summing up all the different values returned by XLOOKUP.", 'start': 529.042, 'duration': 9.81}, {'end': 544.538, 'text': 'With XLOOKUP, you can also look up based on multiple criteria.', 'start': 539.313, 'duration': 5.225}, {'end': 546, 'text': "Let's take a look.", 'start': 545.359, 'duration': 0.641}, {'end': 555.929, 'text': "On the next worksheet titled multiple lookups, I want to know how much does our classic chocolate chip cookie cost? And yes, that's right.", 'start': 546.741, 'duration': 9.188}], 'summary': 'Xlookup can be nested in functions, allowing lookup based on multiple criteria.', 'duration': 26.887, 'max_score': 529.042, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA529042.jpg'}, {'end': 605.6, 'src': 'embed', 'start': 576.707, 'weight': 3, 'content': [{'end': 580.412, 'text': "Let's click into XLOOKUP and here for the lookup value.", 'start': 576.707, 'duration': 3.705}, {'end': 582.495, 'text': "First off, let's select chocolate chip.", 'start': 580.612, 'duration': 1.883}, {'end': 588.443, 'text': "Then I'm going to insert the ampersand symbol and then I'll select classic.", 'start': 583.076, 'duration': 5.367}, {'end': 591.347, 'text': "So here we're looking up two different values.", 'start': 588.784, 'duration': 2.563}, {'end': 594.931, 'text': 'In the lookup array, we do the exact same thing.', 'start': 592.148, 'duration': 2.783}, {'end': 600.235, 'text': "Here I'll select this column, I'll insert the ampersand, and then I'll select this column.", 'start': 595.351, 'duration': 4.884}, {'end': 605.6, 'text': "And then for the return array, I'll select the price per cookie and then click OK.", 'start': 600.776, 'duration': 4.824}], 'summary': 'Using xlookup to search for chocolate chip & classic, and return the price per cookie.', 'duration': 28.893, 'max_score': 576.707, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA576707.jpg'}], 'start': 81.288, 'title': 'Using xlookup in excel', 'summary': 'Demonstrates how to efficiently find the price of a chocolate chip cookie using the xlookup function and showcases its functionality, including vertical and horizontal lookup, searching across multiple worksheets, returning multiple values, nesting within other functions, and looking up based on multiple criteria.', 'chapters': [{'end': 158.306, 'start': 81.288, 'title': 'Xlookup function for cookie price lookup', 'summary': 'Demonstrates how to use the xlookup function to efficiently find the price of a chocolate chip cookie from a table, simplifying the lookup process.', 'duration': 77.018, 'highlights': ['The chapter demonstrates how to use the XLOOKUP function to efficiently find the price of a chocolate chip cookie from a table, simplifying the lookup process.', 'The XLOOKUP function is highlighted as the key method for performing the cookie price lookup, providing an efficient solution for the task at hand.', 'The demonstration includes using the insert function helper to easily access and implement the XLOOKUP function, streamlining the process for users.']}, {'end': 600.235, 'start': 158.846, 'title': 'Xlookup in excel', 'summary': 'Introduces xlookup in excel, showcasing its functionality such as looking up values vertically and horizontally, searching across multiple worksheets, returning multiple values, nesting within other functions, and looking up based on multiple criteria.', 'duration': 441.389, 'highlights': ['XLOOKUP can return multiple values by selecting multiple columns in the return array, allowing for retrieval of both price and cost for a specific cookie type. XLOOKUP can return multiple values by selecting multiple columns in the return array, allowing for retrieval of both price and cost for a specific cookie type.', 'XLOOKUP can be nested within other functions, demonstrated by using it within the sum function to calculate profit based on the returned values. XLOOKUP can be nested within other functions, demonstrated by using it within the sum function to calculate profit based on the returned values.', 'XLOOKUP allows for looking up based on multiple criteria by using the ampersand symbol to combine different values in the lookup and return arrays. XLOOKUP allows for looking up based on multiple criteria by using the ampersand symbol to combine different values in the lookup and return arrays.', 'XLOOKUP can search across multiple worksheets, enabling retrieval of values even if the table is on a separate sheet. XLOOKUP can search across multiple worksheets, enabling retrieval of values even if the table is on a separate sheet.', 'XLOOKUP is capable of looking up values both vertically and horizontally, as demonstrated in the examples with vertical and horizontal data presentation. XLOOKUP is capable of looking up values both vertically and horizontally, as demonstrated in the examples with vertical and horizontal data presentation.']}], 'duration': 518.947, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA81288.jpg', 'highlights': ['The chapter demonstrates how to use the XLOOKUP function to efficiently find the price of a chocolate chip cookie from a table, simplifying the lookup process.', 'XLOOKUP can return multiple values by selecting multiple columns in the return array, allowing for retrieval of both price and cost for a specific cookie type.', 'XLOOKUP can be nested within other functions, demonstrated by using it within the sum function to calculate profit based on the returned values.', 'XLOOKUP allows for looking up based on multiple criteria by using the ampersand symbol to combine different values in the lookup and return arrays.', 'XLOOKUP can search across multiple worksheets, enabling retrieval of values even if the table is on a separate sheet.', 'XLOOKUP is capable of looking up values both vertically and horizontally, as demonstrated in the examples with vertical and horizontal data presentation.', 'The demonstration includes using the insert function helper to easily access and implement the XLOOKUP function, streamlining the process for users.']}, {'end': 985.443, 'segs': [{'end': 829.335, 'src': 'embed', 'start': 757.324, 'weight': 0, 'content': [{'end': 763.785, 'text': 'I see an option for search mode and here I could perform a reverse search, starting at the last item.', 'start': 757.324, 'duration': 6.461}, {'end': 765.886, 'text': "Here I'll enter minus one.", 'start': 764.366, 'duration': 1.52}, {'end': 772.668, 'text': 'I also have the option to use a binary search, but for that I have to either sort it in ascending or descending order.', 'start': 766.526, 'duration': 6.142}, {'end': 782.355, 'text': "I'll enter the negative 1, click on OK, and here I see that Lola's last order was on 7-13, so yet another option that you can customize.", 'start': 773.388, 'duration': 8.967}, {'end': 792.283, 'text': "We're making fantastic progress on XLOOKUP, and last I want to leave you with perhaps the most advanced and complicated scenario.", 'start': 783.096, 'duration': 9.187}, {'end': 797.166, 'text': 'You can use XLOOKUP to find values in a grid of data.', 'start': 793.163, 'duration': 4.003}, {'end': 802.964, 'text': "To do this, we're going to nest an XLOOKUP within an XLOOKUP.", 'start': 798.194, 'duration': 4.77}, {'end': 807.213, 'text': "I know it sounds complex, but we'll walk through it step by step.", 'start': 803.726, 'duration': 3.487}, {'end': 815.951, 'text': 'This now brings us to the very last worksheet titled nested XLOOKUP and this is the final boss of XLOOKUP.', 'start': 807.808, 'duration': 8.143}, {'end': 818.671, 'text': "You've made it this far so let's get through this.", 'start': 816.111, 'duration': 2.56}, {'end': 827.314, 'text': "We're going to use XLOOKUP to tell us how much money or revenue we earned from chocolate chip cookies in 2021.", 'start': 819.192, 'duration': 8.122}, {'end': 829.335, 'text': "And here you can see that it's a grid.", 'start': 827.314, 'duration': 2.021}], 'summary': 'The transcript discusses using xlookup for reverse search, binary search, and nested xlookup within a grid of data.', 'duration': 72.011, 'max_score': 757.324, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA757324.jpg'}, {'end': 875.204, 'src': 'heatmap', 'start': 848.485, 'weight': 0.705, 'content': [{'end': 854.51, 'text': "I'll click into cell F7, click on the function helper, and here once again let's select XLOOKUP.", 'start': 848.485, 'duration': 6.025}, {'end': 857.332, 'text': "For the lookup value, I'll select the year.", 'start': 854.97, 'duration': 2.362}, {'end': 863.356, 'text': "For the lookup array, here I'll select all of the different years, and for the return array,", 'start': 858.152, 'duration': 5.204}, {'end': 867.459, 'text': "here I'll select all of the different revenue amounts and then I'll click on OK.", 'start': 863.356, 'duration': 4.103}, {'end': 872.022, 'text': 'And here we see all of the revenue for 2021.', 'start': 868.119, 'duration': 3.903}, {'end': 875.204, 'text': 'Next, I want to find the revenue for chocolate chip.', 'start': 872.022, 'duration': 3.182}], 'summary': "Using xlookup, revenue for 2021 is found, and searching for chocolate chip's revenue.", 'duration': 26.719, 'max_score': 848.485, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA848485.jpg'}], 'start': 600.776, 'title': 'Xlookup function and nested grid search', 'summary': 'Explores the xlookup function and its optional parameters for customized searches, including match modes and search modes, and demonstrates nesting xlookup to efficiently retrieve data, such as revenue for chocolate chip cookies in 2021, totaling over 8 million, with automatic updates upon changing variables.', 'chapters': [{'end': 782.355, 'start': 600.776, 'title': 'Xlookup function and optional parameters', 'summary': "Explores the xlookup function and its optional parameters, including match modes and search modes, demonstrating how to recommend a cookie based on customer's budget and perform customized searches, with examples of different match modes and search modes, such as exact match, next smaller item, next larger item, wildcard search, reverse search, and binary search.", 'duration': 181.579, 'highlights': ["The chapter explains the XLOOKUP function and demonstrates recommending a cookie based on a customer's budget, showcasing different match modes. It discusses recommending cookies based on customer's budget using different match modes, such as exact match, next smaller item, and next larger item.", 'It showcases examples of different search modes, including reverse search and binary search, to customize search options. It demonstrates customizing search options using search modes, such as reverse search and binary search, to find specific information in a dataset.', 'The chapter covers using the XLOOKUP function and its optional parameters, providing insights into customizing search and match options for specific scenarios. It provides insights into customizing search and match options using the XLOOKUP function, allowing for tailored recommendations and customized searches.']}, {'end': 985.443, 'start': 783.096, 'title': 'Xlookup nested grid search', 'summary': 'Presents the most advanced and complicated scenario of using xlookup to find values in a grid of data, demonstrating how to nest an xlookup within an xlookup to efficiently retrieve revenue data for chocolate chip cookies in 2021, totaling just over 8 million, and enabling automatic updates upon changing variables.', 'duration': 202.347, 'highlights': ['Demonstrates nesting an XLOOKUP within an XLOOKUP to efficiently retrieve revenue data for chocolate chip cookies in 2021, totaling just over 8 million, and enabling automatic updates upon changing variables.', 'Illustrates using XLOOKUP to find values in a grid of data, showing step-by-step guidance on selecting lookup values, lookup arrays, and return arrays to successfully search across a grid.', 'Provides a tutorial on using XLOOKUP to find revenue for specific years and cookie types, showcasing the process of selecting lookup values, lookup arrays, and return arrays to obtain accurate results.']}], 'duration': 384.667, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HXU7lsd0ftA/pics/HXU7lsd0ftA600776.jpg', 'highlights': ['The chapter covers using the XLOOKUP function and its optional parameters, providing insights into customizing search and match options for specific scenarios.', 'Demonstrates nesting an XLOOKUP within an XLOOKUP to efficiently retrieve revenue data for chocolate chip cookies in 2021, totaling just over 8 million, and enabling automatic updates upon changing variables.', 'Illustrates using XLOOKUP to find values in a grid of data, showing step-by-step guidance on selecting lookup values, lookup arrays, and return arrays to successfully search across a grid.', 'It showcases examples of different search modes, including reverse search and binary search, to customize search options. It demonstrates customizing search options using search modes, such as reverse search and binary search, to find specific information in a dataset.']}], 'highlights': ['XLOOKUP function in Excel allows users to look up values, providing a practical example of finding the price of a specific type of cookie in a table.', 'Demonstration includes a basic example showcasing the fundamentals of how XLOOKUP works, with subsequent mention of more advanced capabilities.', 'XLOOKUP is exclusively available for Microsoft 365 subscribers, while alternative methods such as VLOOKUP and HLOOKUP are also provided for non-subscribers.', 'XLOOKUP can return multiple values by selecting multiple columns in the return array, allowing for retrieval of both price and cost for a specific cookie type.', 'XLOOKUP can be nested within other functions, demonstrated by using it within the sum function to calculate profit based on the returned values.', 'XLOOKUP allows for looking up based on multiple criteria by using the ampersand symbol to combine different values in the lookup and return arrays.', 'XLOOKUP can search across multiple worksheets, enabling retrieval of values even if the table is on a separate sheet.', 'XLOOKUP is capable of looking up values both vertically and horizontally, as demonstrated in the examples with vertical and horizontal data presentation.', 'Demonstration includes using the insert function helper to easily access and implement the XLOOKUP function, streamlining the process for users.', 'Chapter covers using the XLOOKUP function and its optional parameters, providing insights into customizing search and match options for specific scenarios.', 'Demonstrates nesting an XLOOKUP within an XLOOKUP to efficiently retrieve revenue data for chocolate chip cookies in 2021, totaling just over 8 million, and enabling automatic updates upon changing variables.', 'Illustrates using XLOOKUP to find values in a grid of data, showing step-by-step guidance on selecting lookup values, lookup arrays, and return arrays to successfully search across a grid.', 'Showcases examples of different search modes, including reverse search and binary search, to customize search options. It demonstrates customizing search options using search modes, such as reverse search and binary search, to find specific information in a dataset.']}