f*******a
发帖数: 15 | 1 本人菜鸟一枚，紧急向牛人请教一个问题。Excel中Sheet1比Sheet2多很多行，我把问
题简化了一下，如下图所示，需要在sheet1中找出与sheet2重复的A列人名，并在新的
sheet3中合并两个表中的不同信息，例子中是Age, Gender, Zip Code, State.
紧急求助怎么用Vlookup操作？非常感谢！
Sheet1
A B C
NAME AGE GENDER
JOHN 40 M
SEAN 32 M
ERIC 24 M
LISA 56 F
MINDY 28 F
LEO 34 M
TONY 41 M
JEAN 26 F
LANCE 36 M
Sheet2
A B C
Name ZIP CODE STATE
MICHAEL 36295 MI
SEAN 37594 OH
ERIC 83620 CA
LINSEY 36422 NY
JOHN 46327 WA | i**M
发帖数: 108 | 2 Starting from sheet 2 since it has less rows, add another column named "Flag
", using formula if(iserror(match(XX,XX,0)),1,0) ie matched names return 1
otherwise return 0. Then sort sheet 2 according "Flag" and you get your
matched names and you can do your vlookup in sheet 3 now. |
|
