because we all know why we’re here so i didn’t include this in the formulas video last week because i knew this was going to be a large one and a lot of people are going to want to know how to do this what the difference between vlookup and xlookup is so it has its own dedicated video to it so let’s get started it is a formula so we’re going to come in here in the cell we’re going to hit equal and then we’re going to start typing x lookup now i’m going to hit tab in just a second but let’s read what this says it says searches a range or an array for a match and returns the corresponding item from a second range or array by default an exact match is used so really useful to know we’ll talk a little bit more about that in just a second let’s hit tab and it’s going to complete it and it’s going to start giving us or it’s going to tell us what our input values need to be we’re going to have our lookup value we’re going to have our lookup array our return array and then some optional things like if not found so if your option isn’t found you know what will be um you know the the