In the "Col_index_num" field we enter the value "2", because in the second column we have the price that we want to receive when searching for the goods. In the "Table_array" field enter the range of all values of the first table A3: B7. In the "Lookup_value" field, we enter a reference to the cell under the product name of the second table D3. We fill in the arguments of the function.In the appeared dialog box on the category field, select the "Lookup and Reference" from the drop-down list, and then specify the function below. Or you can press the hotkey combination SHIFT+F3. To do this, click on the "fx" button, which is at the beginning of the formula bar. You can also enter =VLOOKUP() using the "Insert Function". Choose "FORMULAS" - "Lookup and Reference" - "VLOOKUP".We move to the cell of the second table under the name of the column "Price".Nearby is another table, which will search in the first table using the criteria “name of the product” and get the value of the corresponding price. For example, if the table consists of two columns: "Product name" and "Price". The VLOOKUP function is used to retrieve data from an Excel table using certain search criteria. How the VLOOKUP function works in Excel: an example
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |