Col_index_num has value 2, as we want to pull value from the second column of the range. The parameter table_array is $B$3:$C$7 because we want to find value from the range B3:B7. In our example, the lookup_value is the E3 cell in “Product ID” column. Our goal is to obtain data from the “Product Description” column in the second table and populate it into the cell F3. Get the Product description using the VLOOKUP function Tables consist of the columns “Product ID” and “Product Description”. In the range B2:C7 we have a table from which we want to pull data, while in in the cell F3 we want to get a value. In this example, our data is organized vertically, so we will use the VLOOKUP function. Data that we will use in the VLOOKUP example Setting up Our Data for the VLOOKUP Functionįigure 1. This means that we want to find an exact match for a lookup value. col_index_num – a column number in table_array from which we would like to get 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: In this tutorial, we will compare the VLOOKUP and HLOOKUP functions and walk through examples of the when to use each Syntax of the VLOOKUP formula While working in Excel, we often need to get a value from a table based on a specific value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |