so it’s going to find toby flenderson it’s going to come over here and it’s going to return toby flenderson at dundermifflandcorporate.com that’s what it should do let’s see what it actually does it says enter and it returns it now if we drag it down like this it’ll apply it to all of these names right here and it works exactly how it’s supposed to um again if you have never used vlookup you don’t know how good you have it okay vlookup was extremely useful but just a bit complicated and i’ll talk about that near the end of the video when we compare vlookup to x lookup but just know that if you’re using x lookup for the first time you’re just getting into using excel you guys have it good okay so just know that um now let’s go over here to x look up XLOOKUP w Multiple Rows multiple rows because you can return more than one output with um with x lookup so let’s go right in here and we’re going to basically write the exact same thing as we did before so let’s write x lookup we’re going to do toby flenderson as our value we’re going to search here and we’re going to do something a little bit different this time we want to include our end date and the email so what we’re going to do is we’re going to start here we’re going to go down all the way to the bottom of end date and then we’re also going to include the email and when we do that it will in in the output give us a row or a column for end date and a column for email so an output for both so let’s hit