China Naming Network - Ziwei Dou Shu - Excel vba cross-workbook data extraction

Excel vba cross-workbook data extraction

Two simulation tables are made, as shown below.

Table 1

Table 2

Then use vlookup function to extract the number of table 2 in table 1, and the formula is =VLOOKUP(B2, Sheet2! A: B, 2, 0), drop down.

Item #N/A is not in Table 2 and cannot be extracted.