Hey everyone, Kevin here. Today I want to show you how you can use VLOOKUP in Microsoft Excel. VLOOKUP is one of the most popular functions in Excel. If there’s a good function to know how to use, this is a really good one To add to your toolbox. In fact, when I worked at Microsoft, this is a function that I used All the time. So what is VLOOKUP and what does it even stand for? VLOOKUP stands for vertical look up and it allows you to look up information in a vertical list. So, let’s take an example. Let’s imagine that you have a customer ID and you want to know the customer’s name. So, you have a list with all the IDs And the customer names, you can look up that ID and then get the customer name back. Or maybe you have two different tables of information, and you want to bring them together. You can use VLOOKUP to join those two separate tables. It’s really versatile. Today we’re going to start off by going in depth on how you use VLOOKUP. Then I want to show you a variation of VLOOKUP called HLOOKUP where you can look up information in a horizontal list, and then at the very end, I’ll save the best for last, I want to show you how you can use something called XLOOKUP, which improves upon both VLOOKUP and HLOOKUP. Now if all of this sounds a little bit overwhelming and maybe a little bit confusing, don’t worry. We’re going to walk through all of this step by step, and if you want to follow along, I’ve also included a sample workbook in the description. You can click on that and then you can follow along with this video. All right, well, why don’t we jump on the PC and let’s start looking up. Here I am in Microsoft Excel now and once again if you want to follow along, I’ve included a link to this workbook in the description of this video, and in this workbook, we’re going to start all the way on the left-hand side with this sheet called VLOOKUP exact match. We’re going to work our way through here and by the end of this video, you are going to be an expert in looking up using VLOOKUP, HLOOKUP, and also XLOOKUP. OK, so let’s get started with a really simple example that’ll demonstrate how you can use VLOOKUP. Right here on this sheet, I have a table of customer information. Over on the left-hand side, I have the customer ID. There are five different customers. Then you see the customer name and then there’s some notes about the customer. Now over here, I want to be able to type in a customer ID. So, let’s say I type in customer ID number 4. Once I type that in, I want to look up this value over in this table and then I want to get the customer name back. So this is just a really simple example. And we’re going to dive in in just a moment, but before we dive into the nitty gritty of how you use VLOOKUP, I want to take a moment to talk about how you should organize your data. Over in the look up table over on the left-hand side, you want to make sure that the value that you’re looking up is the leftmost column. So here I’m looking up the customer ID, and over here in this table, the customer ID right now is already the leftmost column. So, if you have to rearrange your data so the look up values over on the left, feel free to do that before using VLOOKUP. Along with making sure that the lookup value is in the leftmost column, you also want to make sure that your look up column is sorted in ascending order. This helps VLOOKUP make sure that it’s finding the right value. So here you see that I have one at the top and then it grows all the way down to five. Also, if let’s say you’re looking up different names, you want to make sure it’s in alphabetical order, starting with A all the way down to Z. So, let’s say that it’s not in ascending order. It’s easy to change that. You can go up to the header of your column. You could right click on that and then you can go down to sort and here you could Sort A to Z. Also, alternatively, you can also go to the data tab up on top and here you can click on filter. So here I’ll toggle it off and I’ll toggle it back on, and over here I can click on the filter and here too I could also sort from smallest to largest. Next, you also want to make sure that there’s a common field that you can use to make a connection, so over here, I’m looking up the customer ID, and this table also has a customer ID, so when I look up 4, I’ll be able to find a match over here. Now I wouldn’t want to look up, say, the address of the customer, because this table doesn’t have an address, so I wouldn’t be able to match on anything, so that wouldn’t really make any sense. Lastly, it also helps tremendously when you do a VLOOKUP to look up on a table of information and you don’t necessarily have to make it a table, but it makes it a lot easier and it’ll also help you avoid some errors. So, you might be wondering, well, how do I turn data into a table? Well, let’s jump to this next sheet here called VLOOKUP Make Table, and I’ll show you how you can make a table. So right now, this is organized in what looks like a table, but it’s not an official Excel table, and it’s really easy to turn this into a table. Right here, once I have all of the data selected, you can go up to insert up here on the top tabs, and here’s an option to convert it into a table. When I hover over you also see that the shortcut key is CTRL + T, so I could also press that to make it a table. Let’s try the shortcut key. I’ll press CTRL + T, and here it says, what’s your table, and so I’ve already selected it, so here it identifies all of it, and my table has headers, so I’ll make sure to check this box and then click on OK and look at that. I now have a table of information, so that worked exactly how I wanted it to. Now let’s go back to the previous sheet. We’ve gone through a bunch of information about how you should structure your data before running a VLOOKUP and all that’s very important because this ensures that when we run the VLOOKUP, we’ll be running it correctly. Next, I want to enter my VLOOKUP function, so over here, for this cell, where I want the name to appear, I’ll click in here and then let’s go up to the formula bar and I’m going to click on this FX symbol. Let’s click on that. This opens up a prompt where we can enter in our function and we want to use VLOOKUP, so right up here, type in VLOOKUP and then click on go. Right here I see the function, so let’s double click on that. This now opens up another prompt where I can enter in all of my function arguments and we’re going to walk through these to help you understand what they mean. So let me pull this down a little bit so we can see it and we can see all of our data up above. First, I need to enter a look up value, and this is bolded here meaning that it’s a required argument that I need to enter, and the lookup value. Well, I want to look up customer ID number 4. So I’m going to click over in this cell and that’s now selected F2. That’s my lookup value. We’re going to look up 4. Right down below. Here I can verify that it’s kooking up 4. Here, it’s showing me the value right here. Next it asks me to enter the table array, and this is where I’m doing the look up, and over here, I want to look up against this table, so here I’ll select the entire table and so one of the interesting things is since we defined this as a table, here it refers to that table. Now, once again I mentioned that it’s a very good practice to turn your table array into a table first, and you might be wondering, well why is that? Well, let’s say maybe I added another customer. The table would automatically account for that. If instead I went through and, let’s say I just selected some cells. If, let’s say I added another customer or another row, it wouldn’t account for it and then maybe my VLOOKUP wouldn’t work properly. So, it’s a good practice to create a table. Now you might also be wondering, well, instead of creating a table, couldn’t I just select all of these columns and then run a VLOOKUP? One downside with that is, let’s say you have content underneath your table. Those might also be included in the VLOOKUP, so once again, as a best practice, create a table and then you could just search across that table. It tends to avoid errors in the long run. I’ve now selected my table and next there’s another argument here called the column index number. So right now, I’m looking for the value for in this table over here. So it looks over in the first column and it says is there number 4? And here it’ll find the number 4. Now this next argument says well which column do you then want to return? So I’ve selected this table and it has three columns, one, two, and three, and I want to send the name back and the name is the 2nd column. So right here I’ll enter the number 2. And last, there’s something called range lookup and in a moment I’ll go into more detail on what that means, but for now, let’s set it to false. We want this to be an exact match. What I mean by that is when it finds customer ID number 4, it’ll look in this list and only if it finds the exact value for number 4, will it return the customer name. Let’s say I sent in customer ID 3.5 or 4.5 or customer ID 6. Well, there is no exact match, so that would return an error. I want this to be an exact match, so once again I’ll enter false, and a little later, I’ll show you when you might want to enter true for this. Now this all looks good and down below I can already see the output. It looks like Wholesome Foods is customer ID number 4. I’ll click on OK and here I see the exact value I was expecting. Now because I have the VLOOKUP set up, here I can type in another customer ID. So I can type in customer ID number 1 and here I see the associated customer. I could also type in customer ID number 5 and that’ll show me the customer associated with number 5. So pretty cool stuff. Now we have VLOOKUP working. With the V look up, let’s say that maybe I enter a customer ID that doesn’t exist, so let’s say I enter number 6. Right here you can see there is no customer 6. When I press enter, I get this #N/A error back and it doesn’t really look that friendly. Now, if you’ve done VLOOKUPs before, you’ll start to recognize that any time you get this, it simply means that it looked up for that exact value, it didn’t find a match and it returns this back, but once again it’s not that friendly so we can improve upon this. To improve upon this, we can use another function called IFERROR. If there’s an error, we can show something a little bit friendlier. Right up here on the formula bar, let’s click right after the equal sign and before the VLOOKUP and let’s type in IFERROR. So, I’ll type that in and then let’s open the parentheses. And right now, there are two different arguments. One of them is the value and one of them is the value IFERROR. So, the first one is if there is no error, what should it display, and if there is no error, well, I just want to show the output of the VLOOKUP, so I’ll leave the VLOOKUP here. But let’s say there is an error. I’ll enter in a comma here, and this is where I enter my second argument. I could just put in some quotes and maybe I just say “not found” just so it’s a little bit friendlier. I’ll close the quotes and then I’ll close the parentheses. Once I’m done entering that in, I’ll hit enter and here now you can see that it looks a lot friendlier. So, if I type in customer 5, well, we have a customer 5 so it shows me that customer name. But here if I type in customer 6, now it says not found instead of #N/A, so that looks a little bit nicer. Next I want to show you how closest match works. In this example, we were looking for an exact match, but when would you use a closest match? And for that, let’s go down to the different worksheets over here and click on the one called VLOOKUP closest match. On this next worksheet, I have two different tables of information. I have cookie orders over here, so here I have an order ID and then I have a certain number of cookies that that customer ordered, and I want to offer some free cookies, just as an incentive to order more. So here for example, if you order 100 cookies, we’ll throw in five for free, so you get 5% free cookies. Or if you order 400 cookies, you get 20 free cookies, so just as an incentive to drive more people to order cookies. Now I want to put in how many free cookies I should include in each order, but I don’t want to have to go through, and say, hey look at how many cookies they ordered and then figure out where that sits on this table. And in fact, when you look at this, here’s someone placed an order for 26 cookies. There is no 26 in this other table. This is where we can use closest match. Another good example is, let’s say you’re calculating taxes and you have different tax brackets. That’s another instance where you might want to use closest match. Just like we did before, let’s go over into cell C2 and we’re going to enter in our VLOOKUP formula. Once again let’s go up to the formula bar and click on the FX. This opens up insert function and right down here you should see VLOOKUP as a recent function. I’ll click on this one. Once again, we can enter in the different function arguments. Here I need to enter my look up value and I want to look up how many cookies they ordered. So, if someone orders 26, well, how many free cookies should we give? So here the lookup value is 26. Right down here, I need to select the table array and I’m looking it up against this table over here, so here I’ll select this table. Right down here, it says what index or what column do you want to send back? So here I’ll look up 26 and here it’s going to look it up against the leftmost column and when it finds out what bucket it falls in, then I want to give back how many free cookies I should include. And that’s the second column, so I’ll enter a 2 here. Now with range look up this time instead of doing an exact match, I want to use a closest match, and if I don’t enter anything at all in this field, it’ll default to using closest match, so I’ll just leave it blank and then let’s click on OK. And look at that, using the VLOOKUP, I now know how many free cookies I should include as each one of these orders, and so you might be wondering, well, how does closest match work exactly. So here, let’s just take a look at this example. A customer ordered 26 cookies and that falls between 0 and 100, so it’s greater than zero, but it’s less than 100, so it finds the closest value that’s less than it, so the closest value to 26 is zero and also 100 is close, but it falls back to zero because that’s less than 26. So here it uses this value. With 101, it’s greater than 100, but it’s less than 200, so it falls back to the closest value that’s less than. And so here in this case, we include five cookies. So there you can get a feel for how it works, or even here’s another example where it’s 392, so it’s between 3 and 400. It’s closer to 400, but 400 is greater than it, so it falls back to 300 and then we’ve included 15 free cookies. Now hopefully you’re starting to get a feel for how VLOOKUP works and the great thing is, when you use VLOOKUP, your two tables don’t have to be on the same sheet. In fact, you can have them on completely separate sheets. Let’s jump over to the next sheet called VLOOKUP Across Sheets, and here’s this same exact example. Except with this example, I don’t have the other table sitting right next to it. Instead, the other table is on this second sheet, so let’s see how we could run the VLOOKUP to get the same results. Here again, I’ll click into this cell. Let’s click on FX up on the formula bar. This opens up the insert function. Let’s select VLOOKUP. Right here the lookup value, once again, I’m looking up the cookies ordered. Next I need to type in the table array, so I’ll click over here and then let’s jump to this next sheet and this is the table I want to look up against, so I’ll select that and here just like we did previously, I want to return the second column. And here with the range look up, I’ll leave that blank, so it’ll be a closest match. Next, let’s click on OK. And look at that, the VLOOKUP works just like before, except this time it’s working across different sheets. Next, let’s go down and let’s click into HLOOKUP to see how we can do a horizontal look up. Now so far, we’ve been doing vertical look ups. Our tables organized in a vertical list. But what if you’re looking up against a table that’s organized horizontally? We can use something called HLOOKUP and it’s the exact same concept as VLOOKUP, but we’re using it against horizontal data, so let’s just test this out to see how it looks, and right up here, let’s select this cell here and then let’s go to the formula bar and click on the FX. This once again opens up the insert function prompt and this time let’s Type in HLOOKUP, click on go, and then select HLOOKUP. Hopefully by now this prompt is starting to look very familiar. First off, we need to select the lookup value, and once again, I’m looking up how many cookies were ordered. Right down below, this is now my table array that I’m looking up against. I want to see how many they ordered and then I’ll decide how many free cookies to give back. So here I’ll select table array and I’ll select this table. Now the key difference here is this is now a horizontal table instead of a vertical table, and that’s fine. It works just the same, except we need to use a function called each HLOOKUP. And over here it says the row index number, so it’s not a column index, it’s a row index. So, in this table over here, we want to send back the 2nd row. So here I’ll type in a two. Also, here for range look up, I’ll just leave it blank. We’re going to do a closest match again and then let’s click on OK. Now here once again we see that if a customer ordered 26 cookies, well for 26 cookies, that’s between zero and 100, so we give free, we give 0 free cookies back. One of the things you’ll notice though is I got this #N/A for all these other values, so I don’t think it’s working quite right. Let’s click back into the formula bar to see what’s going on. Here for the table array, I’m just looking at these cells. These are relative cells. Here as I go down, if I click into this cell, you see that it automatically adjusts the table that it’s looking against. I don’t want it to do that, so instead I can go up to the top and I need to make it an absolute reference. So, as I pull this formula down, it continues to look at this table. To do that I can press the F4 key. I can press the F4 key again, and then I’ll hit enter, and now you see that the formula works properly. That’s one of the downsides of using a horizontal table in Excel. You can’t properly define it as a table, so you have to make sure that you use an absolute reference, and I think most people, when they organize data in Excel, they tend to use a vertical list. Horizontal lists aren’t as popular, but I did want to touch on how you can use each HLOOKUP as well, depending on how your data is formatted and organized. Now by now your look up skills should be getting pretty good, but what if I told you there is an even better version of looking up? And that’s called XLOOKUP. It can do everything that VLOOKUP and HLOOKUP can do, but it can do even more. On its own, it can search on vertical and horizontal lists, so you don’t need separate functions, and it does a lot more than just that, and in a moment, we’re going to run through to see what some of those additional benefits are. And for that, let’s go down and click on the worksheet called XLOOKUP. I’m now on the XLOOKUP worksheet and let’s take a look at how this works. Over on the left-hand side I have a table with a whole bunch of cookie orders. I have an order ID, I have what product they ordered, how many we sold, the date, and then I have a bunch of empty columns. I have the revenue per cookie, the costs per cookie, and the order profit, and I don’t know what those are. Luckily though, I have a nice reference table over here that tells me how much revenue per cookie, how much cost for cookie, and then here I have the cookie type, and look at that, I can match based on the cookie type, so here I have the cookie name and here the product name matches with the cookie type exactly. In fact, if I click on this drop-down I can see that all of the cookie types are exactly the same. So we could certainly use VLOOKUP to fill this out, but it’s not going to work quite as well. Now first off, one thing to notice is my cookie type is not the left most column. In fact, here it’s the right most column. So, if I wanted to run a VLOOKUP, well, first off, I’d have to move the cookie type over onto the left-hand side, but why do that? We can use XLOOKUP and we don’t have to rearrange our data. So, let’s go over here and first off, let’s pull in the revenue per cookie for all these different cookie types and let’s use XLOOKUP. And just like we did before, let’s click on the FX. Within insert function, let’s type in XLOOKUP and then click on go, and here you should see the XLOOKUP function. Let’s click on that and then click on OK. This once again opens up function arguments and at first glance you’ll see that there’s more that we can fill in, but more isn’t necessarily bad. Right here, you see the three bolded values, and these are the required values. And down below, you have some optional different settings that you can configure and so really XLOOKUP is going to give you a lot more power and let’s start with the just simplest example. First, I want to look up a value and just like we did with VLOOKUP, well our look up value is over here. We’re going to look up chocolate chip and we want to look it up in this table. So over here, I need to select the lookup array. Now, previously with VLOOKUP, we selected this entire table, but we don’t have to do that anymore. Instead, I’m just going to select this column. I want to look up in this column to find that value. So, one of the nice things is once again I don’t have to rearrange my data. Over here I want to select what I want to return, so I’ll click over here, and I want to return the revenue per cookie. So, in this same table, the revenue is over here, so I’ll select that column, so I don’t have to worry about entering in a column index or row index. Instead I just select what I want to get back, so it’s a little bit more intuitive to use. Now, some of the other benefits. Down here, there’s something called if not found. Remember earlier when we got that #N/A error and we used another function called IFERROR to make it a little friendlier? Well, you don’t have to worry about that anymore. Here you can simply type in something like, let’s say “not found” and remember this is optional, so you don’t necessarily have to do this, but here it’s just built directly in. In a moment, we’ll come back to what match mode and search mode mean, but for now we have our basic XLOOKUP working, so let’s click on OK. So look at that, XLOOKUP has now returned the revenue per cookie, so it looks up here Chocolate Chip. Here it finds Chocolate Chip and it returns this value over to the left for $5, so that’s pretty cool, you don’t have to rearrange your data and here it basically does what VLOOKUP does, but it has a little bit more power. Next, let’s do the same thing just to make sure we really understand this, let’s do it again with cost per cookie. Here I’ll click on the cell. Let’s go back up to FX, and once again, let’s click on XLOOKUP. This opens up the function arguments and over here I want to look up this product type, and I want to look up over here, so I want to find the cookie type over in this table. Next, I want to return the cost, so I’ll select this column. This is what I want to return back and then here, if not found, I’ll just leave that for now. I don’t necessarily need that, and I mentioned we’ll come back to these other items in a little bit. So all of this looks good. Let’s click on OK. And right there I see my cost per cookie. It just automatically populates all of that right here. OK, so next I want to calculate the profit and to do this I’m going to combine multiple functions together and this is going to show you some even more power of XLOOKUP. So, in this order profit cell right here, let’s enter an =SUM. So, to calculate the profit, well I want to sum the revenue and the cost. So basically, my profit on an individual chocolate chip cookie is $3, five minus two, and then I want to multiply it by the units sold and I can do all of this in just one formula up here on the formula bar. So first let’s enter the sum and next I want to use XLOOKUP. So, let’s enter in XLOOKUP and here I’ll enter in the function. Now if we want to make it easy, here we can click over on FX again and let’s fill out the XLOOKUP. This once again opens up the function arguments and the lookup value, well, I want to look up chocolate chip, so I’ll select that. Over here, I’ll select the look up array and it’s this column again. I want to look it up over here. Now for the return array, one of the things that’s really interesting is I can return multiple values and that’s one of the powers of XLOOKUP. So here I want to return both the revenue and the cost and then SUM is going to sum up the revenue. It’ll sum the cost and that’ll give me the profit on a per cookie basis. Now here for if not found and all these others, I’ll leave those as is for now and I’ll click on OK. So here now I have my XLOOKUP in place. Now I’m going to take the value or the profit per individual cookie, and I want to multiply this by the total number of units sold, and then I’ll close my parentheses and hit enter. And just like that, using XLOOKUP together with SUM, I’m able to get the order profit or the overall order profit. So, one of the really neat things with XLOOKUP is I can return multiple values and on the topic of multiple values, why don’t we dig in and see exactly how this works over on the next sheet called XLOOKUP return multiple values. Now previously to get the revenue per cookie and the cost per cookie, we entered XLOOKUP into one column and then we entered it into the next column. But instead of doing that, I can simply pull all of that information back in just one formula. How do we do that? Well, once again, let’s type in XLOOKUP, and then let’s open the parentheses. Now just to make it easier, I’ll click into FX, but you could also enter the formula right here. This opens up the function arguments again and once again the lookup value, I want to look for chocolate chip and over here I can select my look up array and once again my look up array is over here, so I’ll select this column right there. And next I need to select my return array and just like before you can select multiple columns to return. So here I’ll select both revenue and also cost, and then I’ll pull it down, and over here, I’ll leave the others as is and then let’s click on OK. Now check that out. So not only did it return the revenue, but it also returned the cost per cookie, so with just one formula, it sent an array back and I was able to fill that out. So that is pretty cool. Now if I want to pull this formula all the way down, once again I need to make sure that these are absolute references. So here I’ll select F4, F4 and I’ll just set it so this table is all just an absolute reference. Then I’ll hit enter and here I could pull the formula all the way down and here you’ll see then that it will automatically look up both the revenue and the cost for each individual cookie. So, this works exactly how I want it to, but this is yet another benefit of XLOOKUP. Now you might be thinking, XLOOKUP is pretty powerful and this is a, I should probably be using this over VLOOKUP and HLOOKUP, but wait, there is more. Let’s click into the next sheet called XLOOKUP wildcard match and let’s see how this works. Within XLOOKUP, there’s an option called match mode and here you can see all of the different options. Now in VLOOKUP, we were able to do an exact match and we were also able to do an exact match, but if none was found to return a smaller item. With XLOOKUP, we have even more control. We could find an exact match, but if it doesn’t find any, it can return the next larger item. So, if you remember the earlier example with the closest match over here, maybe instead of falling back to the smallest value, maybe I want to go up to the largest value. I can configure that using VLOOKUP. Also, down below I can also set A wild card match, so maybe I want to know, Well, which one is the first customer over here that starts with a W. I can use XLOOKUP to do that, and let’s test this out using option number two. I’ll click in this cell and let’s once again click on the FX. Over here, let’s select XLOOKUP. For the lookup value, I’m simply going to enter quotes and then I’ll type in a W and then I’ll type in an asterisks, and then I’ll type in another quote. So, I want to find a W and I don’t care what comes after the W, and that’s what the asterisk does. Over here I need to select my look up array and just like we did before, I’ll select the customer name right here, so I want to look up the customer over here and if it finds a customer over here, well I want it to return the full customer name so I’ll simply select this as my return array. Now right down here I need to select the match mode and I want this to be a wildcard match, so I’ll enter two and then click on OK. And look at that. The first customer with a W in its name is Wholesome Foods and I get that value back. So once again, this is yet another benefit of XLOOKUP. Lastly, I also want to show you the last big benefit of XLOOKUP and that allows you to define how it should search. Let’s go over and this is the very last sheet in the set. So, congratulations for making it to the very end. Once we go through this, you’ll have a very good grasp of how XLOOKUP works. On this sheet, I want to know when Lola’s last order was. So over here on the left-hand side, you can see Lola is one of our customers and she had an order on January 16th and it looks like her last order was on July 13th. Now with VLOOKUP, it’s going to look from top to bottom, so if I were to run a VLOOKUP, it would return this value. But the nice thing is with XLOOKUP, I have access to these different search modes, so here, just like with VLOOKUP, I could just start at the top and then work my way down. But now I can also start from the bottom and work my way up. If I enter negative one in for the search mode. I also have binary search as an option, and I can enter two or negative two and it’s the same concept. I could start from the top and work my way down or start from the bottom and work my way up. With a binary search though, you have to make sure that you sort the data in either ascending or descending order, so kind of like we did with VLOOKUP earlier. Now let’s try this, and let’s try to find what the last item was with this negative one. I’ll go up here and let’s click into this cell. It doesn’t really matter which cell we enter this in and let’s click on the FX. Next, let’s click on XLOOKUP. For this one, we want to look up Lola, so I’ll type in Lola, and I’ll make sure that I enter it in quotes. So, there we’re looking for Lola and here I want to look it up in this customer column. So here I’ll select the entire column with the customers, and I’ll just highlight it all the way to the bottom. And then for the return array, well I want to get the order date back, so I’ll go ahead and let’s highlight this column. And if not found, I’ll leave that as is. I don’t care about match mode, but down below I can now set the search mode. Once again, for this I want to start from the bottom, and I want to work my way up. So, for that, just like we saw earlier, if I go down just a little bit, we see that to perform a reverse search starting at the last item, I need to enter a negative one. So let me type in a negative one here. Now I’ll click on OK and here now we see that Lola’s last order was on 7/13 and here I can confirm that. If I go down the list, we see Lola and her last order was on 7/13. And that now wraps up all of the functionality of XLOOKUP and so hopefully now by going through these different examples you’re starting to realize the power of using XLOOKUP especially compared to VLOOKUP and also HLOOKUP. In fact, there’s really not much of a reason to even still use VLOOKUP or HLOOKUP when you have XLOOKUP. It can do everything that both VLOOKUP and HLOOKUP can do, but it has even more power and customizability. All right, well if you now know how to use VLOOKUP, HLOOKUP, and also XLOOKUP, please give this video a thumbs up. To see more videos like this in the future, make sure to hit that subscribe button. Also, if you want to see me cover any other topics on this channel, leave a note down below in the comments. That’s where I get a lot of my video ideas from. All right, well, that’s all I had for you today. I hope you enjoyed, and as always, I hope to see you next time, bye.