To match the two vlookup tables, first compare the data of the two tables, enter the formula vlookup in the first column of the inventory, the first parameter is B2, select the range searched by the vlookup function in the inventory table, enter the third parameter value 2, and the last value is 0. Copy the set formula to other cells, and the data will be generated automatically.
Matching method of vlookup two tables
1. Compare the data of the two tables, enter the formula vlookup in the inventory column, and the first parameter is B2.
2. Select the range found by vlookup function in the inventory table, enter the third parameter value, set the third parameter value to 2, and enter the last value to 0.
3. Copy the set formula to other cells in the same column.
4. When all tables have copied the vlookup function, its data is automatically generated. （vlookupLiangGeBiaoZenMePiPei）