Current location - Zhou Gong's Dream Interpretation Network - Baby naming - EXCEL two tables, when the two tables have the same name, take the corresponding number after the name and find the formula.

EXCEL two tables, when the two tables have the same name, take the corresponding number after the name and find the formula.

table 1 A2 is the name B2 cell formula

=IF(ISERROR(VLLOKUP($A2, Sheet2! $A$2：$B$2,2,),"",VLLOKUP(A2，Sheet2! $ a $2: $ b $2,2,))

format handle drop-down copy formula

Sheet2! $ A $2: $ B $2 is the cell area where the names and corresponding data in Table 2 are located.

Related articles