The function pulls this value and returns it to the 1st table (cell C3) as a result.Ĭopying a VLOOKUP Formula using Absolute Cell References As we can see, the value of “Product ID” in B3 in the 1st table is 1003, while in the 2nd table Product description for 1003 is Product C. Using the VLOOKUP function in the single cellĪs a result, we will get Product C in the cell B3. Finally, range_lookup has value 0, because we want to find an exact match of “Product ID” values.įigure 3. Col_index_num has value 2, as we want to pull value from the second column of the range. The parameter table_array is $E$3:$F$7 because we want to find value from the range B3:B7. In our example, the lookup_value is the individual cell in “Product ID” column. This will be done based on each corresponding Product. Our goal is to obtain data from the “Product Description” column in the second table and populate it into the same column of the 1st table.
Get the Product description using VLOOKUP Both tables consist of “Product ID” (columns B and E) and “Product Description” (columns C and F). In the range B2:C7 we have the result table, while in the range E2:F7 we have the lookup table. Let’s start with examining the structure of the data that we will use. This means that we want to find an exact match for a lookup value.įigure 2.
col_index_num – a column number in table_array from which we would like to pull a value.table_array – a range in which we want to lookup.lookup_value – a value that we want to find in a table_array.The parameters of the VLOOKUP function are: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) The generic formula for the VLOOKUP function is: Final result Syntax of the VLOOKUP formula In this tutorial, we will learn how to quickly copy a VLOOKUP formula down a column.įigure 1. This is possible by using an absolute cell reference. While using the VLOOKUP function in Excel, we sometimes need to apply it to a range. How to Copy a VLOOKUP Formula Down a Column
0 kommentar(er)
