Excel references other forms of data
Commodity table 1, see the product code
Commodity table 2, see also the product code
The commodity table 2 in the other two categories of the "title" column copied to the commodity table 1.
Then the following formula reference.
Selected cells in the commodity table 1, and then click on the above fx, select all, find vlookup. point OK
On the content of the Vlookup function to analyze:
Lookup_value "the only value" for the need to find the first column of the array for the reference to the relationship between the value, it can be a numerical value or text string. For example: the example of the product code column, generally the first column of the value, as the only data reference and used. (This form)
Table_array "region": the value of the region, such as "A: D", that is, you want to refer to all the data (want to refer to the data table)
Col_index_unm "Col_index": the number of columns in the table, which can be numerical or text string. unm "column number": the first column inside the reference area value, such as from A to D **** there are 4 columns, I want to quote the value of column B over, then choose 2, because column B in the region of the second column, the other is also the same deduction
Range_lookup". Logical value": generally fill in TRUE or FALSE. refers to the function VLOOKUP return is an exact match or an approximate match. Usually written false.
The first cell references the success of the next pull down (when the bottom right corner of the cell becomes solid, and then pull down, the meaning of the same as the above.)
Another column of the brand is also according to the above method, repeat the 4th and 5th step, you can also directly insert the copy of the first column of the paste operation. Just need to put the third value of the second column 2 to the third column 3. Finish and then pull down the formula.
The effect of the display is shown in the figure below, combining the data of the two tables. Small example of data is not a lot of data, but a huge amount of data, with this method is very suitable,