how to use vlookup in excel 2016 youtube

HOW TO USE VLOOKUP IN EXCEL 2016 YOUTUBE HOW TO

Must Read: How to use VLookup and Sum function to get total for Multiple columns If you want to use VLookup Match function together in Excel, then you must have to follow given simple steps, have a look. Steps to use VLookup Match function in Excel The match_type argument specifies how Excel matches lookup_value with values in lookup_array. Lookup array is the range of cells used for search. The lookup_value argument can be any number, text, logical value or a cell reference to a number, text, or logical value. Lookup value is the value which you want to match in lookup_array. This function returns relative position of an item in the given array or range of cells, which match a specific value in specific order. TRUE: Appropriate Match: This option work properly when first column of your table will be sorted in ascending order only otherwise it displays wrong result.įalse: Exact Match: VLookup by default check only on exact match method. There are two options available in this part. Range_lookup: It is an options part of this function. You can set any cell reference of a range or range name.Ĭol index num is the column index_number in the table from which the searched value must be returned. Table array is Two or more columns of data. Lookup value is used to search in the extreme first column of the table array.

VLookup (lookup_value, table_array, col_index_num, ) This function provide the value in the same row which is based on the index number. Microsoft Excel VLookup function is used to search specific value in the extreme left column of the table_array. The main reason is that the column number is static and it doesn’t change when any column delete or add. If you delete or add any column in table array then you can get either an incorrect result or an error message. Must Read: Excel VLookup Find First, 2nd Or Nth Match Value in Excel?ĭuring searching any specific value, you can view any error when any kind of changes are done in your workbook. This function allows you to reduce the chances of error and improve the capability of VLookup function. How to use VLookup Match function in Excel If you need better control over during lookup and match the value then you must have to know how to use VLookup Match function in Excel. Sometime we need to use VLookup and Match function together to lookup specific value. So up next, I'll explain each of the arguments - the values inside the parentheses - along with rules for using VLOOKUP.VLookup Match one of the most powerful and important function in Excel. Now look through this range of cells, and in the third column to the right, find the value on the same row.” So what just happened? I told Excel, “Here is a value in the left-hand column of my data. When I press Enter to tell Excel I am done, you can see I get an error message because I haven't entered a value in cell H2.īut, when I enter a part number, I get a price. In other words, it's the third column over from the part numbers, the data I know.Īnother comma, and I enter FALSE, because that gives me an exact match between part number and price.Īnd don't worry, I'll explain how that works later.

This tells VLOOKUP that the values I want to see are in the third column from the left in the range of cells I want to search. So, I'll enter B3, a colon, and E52, then I'll type another comma.Īnd you need to do that because the functions won't work without the colons and commas. The part numbers start in cell B3, and if I scroll down, you can see the status values end at cell E52. I'll enter H2 as the first argument, because that is where I'll type the part numbers.įollow that with a comma, and then, I'll enter the range of cells that contains the data I want to search. These parentheses will contain a set of arguments, and an argument is just a piece of data that the function needs in order to run. To do that, I'll click the cell where I want to see the Prices, I'll enter an = sign, VLOOKUP, and parentheses. So, as an example, I'll enter part numbers, the thing I know, and find out Prices, the thing I don't know.

VLOOKUP works a lot like a phone book, where you start with the piece of data you know, like someone's name, in order to find out what you don't know, like their phone number. When you need to find information in a large spreadsheet, or you are always looking for the same kind of information, use the VLOOKUP function.

How to use vlookup in excel 2016 youtube