It is used as a master list of sorts, and you will use it to locate data that you need to find using search criteria that you will enter into your lookup formula. Since we want the exact match, we enter FALSE.Ī lookup table is created by simply creating a table in Excel. Ours is Column 2. We then enter another comma. Next, we add a comma, then for the table_array, we are going to highlight the cells in the table however, we do not highlight the column headers. The first piece of information we must supply is the lookup value. We know the lookup value is the month located in Column A (the first column), but we must use the MONTH function to specify this, as shown below. We start by entering the VLOOKUP function, then open brackets. On the right, we have created a lookup table. We are going to use a VLookup to find the text value. On the left, we have birthdays listed. We know that 12 means December, and we could use the MONTH function to fill in December for us, but instead we want the text value.
ADVANCED VLOOKUP IN EXCEL 2016 HOW TO
Let's learn how to use the VLookup formula. Range_Lookup is typically true for false. True will give you a near match. If you want to find an exact match, it is false. The table_array is the table where the data will be retrieved. This value can be a range or the name of a range.Ĭol-index_num is the column number in the table. The first column in your table is column 1. Lookup_value is the value that we want to look up.
ADVANCED VLOOKUP IN EXCEL 2016 TRIAL
It is a lot less trial and error that way.įor the time being, however, let's look the formula in our worksheet again. If you are newer to Excel, it is recommended that you use the Function Arguments dialogue box to create your formulas. The benefit of using the dialogue box when entering a formula is the bit of instruction that Excel gives you for each field. You can also go to the Formulas tab, click the Lookup & Reference button, then select VLookup.
Inside the brackets, you will see the information that Excel asks us to enter into the formula.
There is VLookup where the V stands for vertical, and there is HLookup where the H stands for Horizontal. In Excel 2016, there are two main formulas for looking up the data you have in a worksheet. Data lookup is quite simply the process where values in Excel are scanned until certain results are found.