VLOOKUP function – a function that searches for a given table (vertically in columns) compares the values in a given column with the values of the given column of the second table and as a result returns a specific value for which there is a common value or a match.
By using this tool we are able to connect two tables with the same type of data.
Let’s say we have a table in a list of traffic of goods in the shops and item codes, and that the need to supplement the list with data from the same catalog of the goods.
Catalogue of goods represents a list with all the data about the goods that we sell as shown below:
Using VLOOKUP function, we can pair the items from the two tables and fill in the blanks with the appropriate data. What will actually happen when we write VLOOKUP function: If you would say to fill in the information in the column Brand – Excel would start with the first item (with code 376084567) sought to that code in our catalog table, I will return when we found Mark Item 376084567th
When we called VLOOKUP function, we get the following window:
As you fill this function Arguments: LOOKUP VALUE - This information will be Excel Search our catalog tables, so here is entered after which the data is searched. In our quest to be a member code (Item) Table string - This is the table that Excel will go and look for matching data, therefore, In our task here to mark our catalog chart. * Note - When you select the catalog to our table, make sure that the first selected column is free of data on which to perform searches in our assignment Item. If this is not the case, reset the table (Be careful not to obstruct the data) so that it suits you. Col index number - I write the number of the column from which we will have us return value when there is a match. I know this sounds complicated, but here's the thing ... See our catalog table, count the columns between the member code (when counting We're moving from a member of the column number that counts as 1). As you can see the Distance column 6 it was a number that can be entered. Range Search - Here you suggest that you always enter FALSE or 0 (zero). Otherwise, if you type 1 or TRUE information that review must be sorted in ascending order.