If you specify TRUE for approximate_match and no exact match is found, the next smaller value is returned.If you specify FALSE for approximate_match and no exact match is found, VLOOKUP will return #N/A.search_value is always in the far left position of lookup_table and is position 1 when determining column_number.Excel will return #REF! if column_number is greater than the number of columns in lookup_table.
The VLOOKUP function in Excel and the two tables When a query is created to the database, the results are output which is a response to the query criteria. The function allows us to quickly find the data and get all the necessary values from the large tables. Now enter the names of the goods for which we need to know its price under the column headline of the second table "Name product". 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