so let’s see if that is our output and it is so you can do this with a lot of things not just some but you’re able to use x lookup within different formulas if you’re searching for a specific value in a specific value in another cell you can add those together using x lookup which is honestly it’s pretty great so let’s go XLOOKUP vs VLOOKUP over to vlookup 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 so axlookup i just showed you kind of everything but super quickly i’m going to show you how vlookup used to work in a super short way so that you can understand how it used to be used and how it is used how x lookup is used now so let’s go in here and we’re going to say equals and we’re going to do a vlookup and so we have a lookup value and so we’re going to click this we’re gonna hit comma just like we did before and now we’re gonna do a table array and the table array is a little different in that you’re searching an entire area so let’s do uh h2 all the way through o oops o ten so that’s what that’s what our table array is going to be then we’re gonna do a comma and now we have to do a column index number which number are we going to be searching for which