顺序不同,至少要有一列关键词相同,这种情况下,用vlookup即可,参考偶的视频教程
EXCEL入门必学的VLOOKUP函数相信偶你终于可以学会了http://excel880.com/blog/archives/1126
{!–PGC_VIDEO:{“hash_id”:11239847644785115596,”thumb_height”:358,”thumb_url”:”15390002b1dbc2b133c0″,”user_id”:2962477694,”neardup_id”:11239847644785115596,”thumb_width”:640,”sp”:”toutiao”,”update_thumb_type”:”2″,”vposter”:”https://p3-sign.toutiaoimg.com/mosaic-legacy/15390002b1dbc2b133c0~noop.image?x-expires=1994702311&x-signature=Lm4gOcQNktlV6dusxh8fqoINtpI%3D”,”vid”:”v02004g10000ceeakijc77u1hgehmcjg”,”duration”:678,”video_size”:{“high”:{“h”:478,”subjective_score”:4,”w”:854,”file_size”:9419726},”ultra”:{“h”:718,”subjective_score”:4,”w”:1280,”file_size”:12377942},”normal”:{“h”:358,”subjective_score”:4,”w”:640,”file_size”:8183689}},”item_id”:6376176335114469890,”media_id”:50090367555,”thumb_uri”:”15390002b1dbc2b133c0″,”group_id”:6376172903869038850,”vname”:”\u770b\u4e00\u904d\u5c31\u80fd\u5b66\u4f1a\u7684VLOOKUP\u67e5\u627e\u6570\u636e\u57fa\u7840\u89c6\u9891\u6559\u5b66.mp4″,”md5″:”44b5463d37263a7e6cc3c86665d88c3b”,”vu”:”v02004g10000ceeakijc77u1hgehmcjg”}–}