 So the next trick is fuzzy lookup. So we're going to do a lookup without a unique key. So I'll show you the Excel files first, and then we'll see how we're going to do this automatically in power query, right? So let me open, I have some Excel files. I'm interested in a lookup Excel files for F3 and results. So if you're a football fan, you'll understand this data. This is, I have dates here, I have my home team, which is Manu. Yes, I support Manu. I'm sorry for you guys that don't. Anyway, yes, yes, we're in trouble nowadays, but we'll get back, we'll come out of it, you know? Can be winning every time, just you have to give other people a chance, right? So anyway, our way team is Leicester. So we have home team, our way team, we have our home score and our way score. Now, anytime we lose, I'm sure it's the referee's fault. So one thing we would like to have is the name of the referee that really manned this whole matches. We need to know the referee's name. I need to know the referee's name here. So where do I get that data? Well, I have another table called referees, which all this data is from the internet, we downloaded it, Amit downloaded it for us, check Amit out, really cool. He went and downloaded football data. I can't remember what team he supports, but anyway, that's fine. So dates, home, away and referee. So if you look at this data, you have your dates, the match happened, home team, away team and referee. So this uniquely identifies, these three uniquely identifies the data. Now, if I was doing VLOOKUP, I mean, all I do to get referee in here, if I was doing VLOOKUP, I want referee, referee. I would need to concatenate, if you guys don't concatenate, concatenate these three, have it as another column, then do a VLOOKUP of that to the other sheet and blah, blah, blah, blah, blah, blah, and then get the referee, right? I'm not gonna do that. No, thank you very much. I want to do all this VLOOKUP without a unique reference in Power Query. So let's see how that works. I'm closing this. Don't save and I'm closing this guy. And yeah, I can do it here in Excel. You know Power Query is in Excel, but I want to do it in Power BI. So I'm back here. So look up without unique key. How do we do that? Let's go to the query. Edit query, so we're gonna bring in, let's just edit query. I'm gonna bring in the data, obviously. So, and then we're now going to do some interesting merging. So here I'm gonna get data, new source is in Excel. I need to browse, this is the lookup. It's referee data and result data. So let's take the result data and we just bring that in. This is my results data. I just take it and say, okay, bring the result data in. Let's call it, this is called results, this is fine. Let's bring in the other data. So that another data, this is my referee data. Right, so this is referee data and result data. So if in Excel I could be probably managing this data and this data keeps growing, so that's fine. So here I want to combine the referee information. All I need from this is this referee. I just want to add this referee to my results. Right, so how do I do that? Let's create a new query. So it's like I need to take results, starting from results and I need to group. I need to merge my query. So I'm gonna create a merge query, but instead of overriding this query, I want to create a new query, merge queries, but as new, as a completely new query. So I'm gonna merge query and starting with my results. I want to merge it to my referees data and here I'm just gonna do a left outer join. All these fields, see these fields here, all the way here. I'm merging it to this fields here, all these fields here. One, two, three, one, two, three. And I'm doing a left outer join, which means this is what I want to join to this one. Right, so anyway, let's see how that works. Let's say, okay, so the selection has matched 790 out of 790, this looks cool. Doesn't it? That means all the data here is all here. So already matched it. So this is VLOOKUP, right? So click okay. And what happens? You have your data that has come in and you have your merge. Let's just call this the, I call it the lookup. We're not done yet, but I'll just call this the lookup. Okay, so I enter lookup. So this is the referee table. I mean, there are free data brought in. If I expand this, all I need from this, I don't need the data, I have the data, I don't need home, I don't need a way. All I need is the referee's name. So click okay. And see, the referee's name comes in. In fact, I can take this guy and take it to the left so that now I have eight home team, away team, referee, and then my data. And these two files are still there. See, these two files are there. I can keep on growing as they like. And then this is my third query, which is my lookup query. Perfect. And I can load this and do all my analysis I like. So that is how you do a lookup even without a reference. You've just created a reference for yourself instead of doing all this in Excel. It's far better and more efficient to do it here in Power Query. So I'll apply the steps. As for results, this I've applied all of them. So as we've done our query. So in fact, all these three, let me create a folder. Let's be a bit neat here. Cause I needed three things here. So I'm going to create a group. And this group, I'm going to call it to the lookup. And it's going to call it lookup, right? And how to do the lookup in Power Query without, even without a reference, right? Even without a reference. Right. So I click okay. So I create a folder and I can now take these three guys. I'll just, unfortunately I can't drag it. Maybe later we can drag. But for now, I just have to right click and say and move to group, lookup, right click and move to group, move to group, lookup, right click and move, come on, move to lookup. To this, I'm just being organized, right? So that's lookup. So what's our next, what's the next trick?