EXCEL复制vlookup公式后,得到的数据都是一样的,sheet1 A列数据如下:100903N-51009008G100905N-11009008G1009008Gsheet2A列 B列数据如下:1004006G-2 130000000483 1006003G-3 130000000494 1005013G 130000000512 1008002G 130000000535 1
来源:学生作业帮助网 编辑:作业帮 时间:2024/09/02 07:23:15
![EXCEL复制vlookup公式后,得到的数据都是一样的,sheet1 A列数据如下:100903N-51009008G100905N-11009008G1009008Gsheet2A列 B列数据如下:1004006G-2 130000000483 1006003G-3 130000000494 1005013G 130000000512 1008002G 130000000535 1](/uploads/image/z/2303406-54-6.jpg?t=EXCEL%E5%A4%8D%E5%88%B6vlookup%E5%85%AC%E5%BC%8F%E5%90%8E%2C%E5%BE%97%E5%88%B0%E7%9A%84%E6%95%B0%E6%8D%AE%E9%83%BD%E6%98%AF%E4%B8%80%E6%A0%B7%E7%9A%84%2Csheet1+A%E5%88%97%E6%95%B0%E6%8D%AE%E5%A6%82%E4%B8%8B%EF%BC%9A100903N-51009008G100905N-11009008G1009008Gsheet2A%E5%88%97+B%E5%88%97%E6%95%B0%E6%8D%AE%E5%A6%82%E4%B8%8B%EF%BC%9A1004006G-2+130000000483+1006003G-3+130000000494+1005013G+130000000512+1008002G+130000000535+1)
EXCEL复制vlookup公式后,得到的数据都是一样的,sheet1 A列数据如下:100903N-51009008G100905N-11009008G1009008Gsheet2A列 B列数据如下:1004006G-2 130000000483 1006003G-3 130000000494 1005013G 130000000512 1008002G 130000000535 1
EXCEL复制vlookup公式后,得到的数据都是一样的,
sheet1 A列数据如下:
100903N-5
1009008G
100905N-1
1009008G
1009008G
sheet2A列 B列数据如下:
1004006G-2 130000000483
1006003G-3 130000000494
1005013G 130000000512
1008002G 130000000535
1009001G-2 130000000538
1008005G 130000000541
1009003G 130000000543
1009002G-1 130000000544
1009002G-2 130000000545
1009003G-2 130000000549
1009005G 130000000550
1009006G 130000000551
1009006G-2 130000000552
1009006G-3 130000000553
1009006G-4 130000000554
1009008G 130000000555
1010002G 130000000556
1010001G-1 130000000557
1010001G-2 130000000558
1010001G-3 130000000559
100708N-5 140000000075
100708N-1 140000000077
100803N-3 140000000089
100804N-4 140000000093
100807N 140000000097
100708N-4 140000000101
100805N-3 140000000106
100901N-3 140000000107
100901N-4 140000000108
100901N-5 140000000109
100901N-6 140000000110
100904N 140000000114
100905N-1 140000000115
100907N 140000000118
100903N-4 140000000122
100903N-5 140000000123
100903N-6 140000000124
100903N-7 140000000125
100906N-3 140000000126
100908N 140000000127
101005N 140000000128
100905N-4 140000000129
100905N-5 140000000130
100905N-3 140000000131
100708N-5 140000000132
101001N-1 140000000133
101001N-2 140000000134
101002N-1 140000000135
101002N-2 140000000136
101002N-3 140000000137
101003N 140000000138
101006N 140000000139
101004N-1 140000000140
101004N-2 140000000141
在sheet1 B1列输入公式=VLOOKUP(A2,Sheet2!A:B,2,0),得到正确结果140000000123,然后一直下拉复制公式,得到的结果都是一样的140000000123,怎么解决.
EXCEL复制vlookup公式后,得到的数据都是一样的,sheet1 A列数据如下:100903N-51009008G100905N-11009008G1009008Gsheet2A列 B列数据如下:1004006G-2 130000000483 1006003G-3 130000000494 1005013G 130000000512 1008002G 130000000535 1
你按F9 看看 刷新不
要是刷新就是自动计算的问题
到工具-选项-重新计算里面
把自动重算√上