output that it gives us a match mode and a search mode and i’m going to show you kind of how to use every single one of these things as you can see at the very bottom i’ve kind of already set up all of the instructional instructional content for this video and so we’ll kind of get through all these different scenarios so let’s just start really quickly with how to use it very simply with the lookup lookup array and return array so we’re going to come in here and we’re going to give it our lookup value now toby flinderson right over here and a3 is going to be our lookup value so that’s who we’re going to be searching for now we’re going to hit comma and now we’re going to be needing to look up uh or to input our lookup array now an array is just a you know a range basically so we’re going to do this is where it’s gonna be searching for um that value this is where it searches for a3 so here’s toby flenderson here’s toby flenderson so it will find it in this array right here