You don’t have to do this step if you want to end the function here, but it does have its uses. The fourth argument is a bit different: You can type FALSE or TRUE here to specify if you want to return either an exact match or an approximate match. Input this number into the function so that VLOOKUP knows what to return. Start counting from the first entry column on the list and count over to the right until you reach the column with the data that you’re interested in (like employee bonuses or student grades). The third argument needs to be a number, not a column letter. Now you need to select the column where the return value is located – aka the specific entry that you want when typing in your lookup value.
How to use vlookup in excel video full#
VLOOKUP now knows the full range of the database or table where it’s looking for information, but it needs a little more help. This is also why VLOOKUP won’t work well with horizontally oriented lists, but that’s rare in spreadsheets. Note that the second argument should always start with the first (leftmost) column in the database or range. For very large databases, manually input the first entry (A2, for example), a colon, and the last entry (B5, in this case), like: A2:B5. It’s simplest to manually click the very first entry and then drag your cursor all the way down to the final bottom-right entry at the end so it encompasses all values in the database. For example, if you are looking up a specific employee ID number, then this argument should contain the entire database. This is the range where your first argument, the lookup value, is located in the range. You can choose where this lookup value goes, but ideally, it will be close to the VLOOKUP for easy analysis and clearly labeled so you will always know what to input.
![how to use vlookup in excel video how to use vlookup in excel video](http://manualgreat.weebly.com/uploads/1/2/4/3/124363423/795217968.jpg)
This is the space where you will be inputting information such as employee or class IDs, specific names, and so on. This is your lookup value, or the identifying information that you will use to pull data about one specific line in a database or directory.
![how to use vlookup in excel video how to use vlookup in excel video](https://images.freecreatives.com/wp-content/uploads/2015/08/best-illusion-painting-ever.jpg)
Remember, think of an example like an employee directory or a class grading sheet to see how this can work in real life. Let’s make it easier by breaking each argument down into how it performs. If you don’t have a lot of experience with Excel functions, that may not make much sense. In brief, you’ll be telling VLOOKUP the value you want to look up, the range where the value is located, the column where the return value is, and if the return needs to be exact or approximate. These define exactly where VLOOKUP will pull information from, so while you start the function with the basic =VLOOKUP(), the four arguments that you put in those parentheses will be doing all the work. The VLOOKUP function is divided into four different “arguments,” or values input into your function.
![how to use vlookup in excel video how to use vlookup in excel video](https://laundrohub.co.za/wp-content/uploads/2016/06/commercial-laundry-nelspruit-scaled.jpg)
Fitbit Versa 3ĭon’t worry, though - this function isn’t nearly as intimidating as it looks, and it can save a lot of time and allow for more freestyle analysis.