vlookup跨表两个表格匹配的方法如下:
工具/原料:联想L1710D&&MacBookAir、Windows10&&macos12.0.1、excel2020。
1、选中单元格
在Sheet2选中需要的单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4034970a304e251f084fd96db586c9177e3e53ee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、输入函数
输入VLOOKUP函数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d000baa1cd11728beb95b1b7dafcc3cec2fd2cee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击查找对象
点击需要的查找对象。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8326cffc1e178a8251844235e403738da877e8ef?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、框选查找范围
在Sheet1框选需要的查找范围。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/43a7d933c895d1437cced9b661f082025baf07ee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、输入查找列数
返回到Sheet2,输入查找列数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2f738bd4b31c8701580e8f73357f9e2f0608ffef?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、输入精确匹配
输入精确匹配:0。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c2ca9bdabe1cf41bd5ac6e39ee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、点击图标
点击【勾】图标。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f636afc379310a55539ce361a54543a9832610ee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、操作完成
vlookup跨表两个表格匹配操作完成。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ac6eddc451da81cb865ebe584066d016082431ee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)