# excel的sheet1如何从sheet2单元格内获取信息


- 在sheet1中输入数据，需要在sheet1的A2输入司机的编号，在B2/C2/D2都可以显示想对应的资料，资料在sheet2中。
![1](https://exp-picture.cdn.bcebos.com/430174fec314f1c5ddb0f0723c27ac5307889df1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)

- 在sheet2中输入司机资料，以便sheet1通过vlookup函数提取对应资料。VLOOKUP(lookup_value,  table_array, col_index_num,  [range_lookup])。表述就是VLOOKUP(查找值，查找范围，查找列数，精确匹配或者近似匹配）

![2](https://exp-picture.cdn.bcebos.com/07c98f2ca5cadce8c016b14ffcf7980e5e2095f1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)

- 在sheet1中的B2中输入=vlookup（A2，  。表示需要通过这个数值来查找想对应的资料。
![3](https://exp-picture.cdn.bcebos.com/76b6860e5f20437109858793323acd8921c58ff1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)


- 通过VLOOKUP函数公式，在sheet1中的B2中输入=vlookup（A2，Sheet2!A1:D13    。这个是资料的查找范围。
![4](https://exp-picture.cdn.bcebos.com/b87bd38920c5260fd46b6c39d2de4507890189f1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)

- 在sheet1中的B2中输入=vlookup（A2，Sheet2!A1:D13,2,      。2表示在范围内的第几列。
![5](https://exp-picture.cdn.bcebos.com/dccb47de45078801592e64f2b18ca608a40f82f1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)

- 在sheet1中的B2中输入=vlookup（A2，Sheet2!A1:D13,2,1）。公式完成，1表示精确查找，0表示广泛查找。
![6](https://exp-picture.cdn.bcebos.com/3931cb413a8ca608c051254fdb8c9bcec6f8fef1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)

- 在sheet1A2中输入2号司机可以看到B2中会显示sheet2中2号司机在B3的资料。
![7](https://exp-picture.cdn.bcebos.com/a749bb0f94fc508cf390764b01775ddd894cfdf1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)

- 在sheet1C2中输入的公式和B2一样.显示效果如图.
![8](https://exp-picture.cdn.bcebos.com/51cd85cec7f88a77368339ff6e4a2f27e6eff8f1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)

- 可以把A2或B2的公式往后拉,在D2中也能得到相应的资料,确保他们都是精确查找的对象或者列数即可.
![9](https://exp-picture.cdn.bcebos.com/8b3643dd884ce54a4179565ca3066b0193ddf7f1.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_jpg%2Fquality%2Cq_80)