请教大家个excel的问题，有关数据统计方面的

1030568958 · 发表于 2011-12-31 11:38

河北-响晴 · 发表于 2011-12-31 11:52

回答你的问题还要扣铜板，楼主还不如直接把问题提出来你呢

qinccckencn · 发表于 2011-12-31 13:10

河北-响晴发表于 2011-12-31 11:52
回答你的问题还要扣铜板，楼主还不如直接把问题提出来你呢

同意,呵呵!!!!

1030568958 · 发表于 2011-12-31 15:40

河北-响晴发表于 2011-12-31 11:52
回答你的问题还要扣铜板，楼主还不如直接把问题提出来你呢

附件怎么才能不扣铜板呢？

1030568958 · 发表于 2011-12-31 15:50

我的问题是：在下面的表格中，想根据D列数值查找B列数值所对应的A列的编号，并将它相应的填在I列中。比如说D10对应B103，在A列中的编号是94，就可以在I10中填94，不知道有这种公式吗？

A	B	C	D	E	F	G	H	I
编号	长度	ID	长度	高程值	厚度	DXF层名	DXF层ID	查找到的编号
1	511.4795	1	897.5004	23	0	TIC	0
2	133.065	2	1120.856	24	0	TIC	0
3	461.7622	3	763.7603	25	0	TIC	0
4	240.1128	4	544.1751	26	0	TIC	0
5	1279.404	5	1557.776	29	0	TIC	0
6	125.5218	6	747.3561	30	0	TIC	0
7	673.9501	7	1175.198	32	0	TIC	0
8	894.2425	8	1265.95	33	0	TIC	0
9	2422.77	9	830.3489	36	0	TIC	0
10	594.1069	10	734.2972	37	0	TIC	0
11	654.7578	11	2006.711	40	0	TIC	0
12	481.9335	12	840.6456	41	0	TIC	0
13	991.4291	13	254.7551	43	0	TIC	0
14	750.0558	14	679.4526	45	0	TIC	0
15	610.7433	15	871.9394	47	0	TIC	0
16	487.4591	16	636.386	48	0	TIC	0
17	493.5103	17	771.8561	49	0	TIC	0
18	759.9144	18	1238.206	50	0	TIC	0
19	807.856	19	1387.747	51	0	TIC	0
20	528.7451	20	1045.906	57	0	TIC	0
21	330.0897	21	321.6461	58	0	TIC	0
22	485.5323	22	1123.004	60	0	TIC	0
23	776.547	23	988.9039	62	0	TIC	0
24	958.5364	24	940.429	64	0	TIC	0
25	457.2244	25	759.9381	65	0	TIC	0
26	477.9953	26	849.5798	67	0	TIC	0
27	833.4152	27	1008.663	68	0	TIC	0
28	586.8982	28	671.8634	69	0	TIC	0
29	716.968	29	820.2217	73	0	TIC	0
30	557.3997	30	689.1867	78	0	TIC	0
31	987.7182	31	782.319	87	0	TIC	0
32	763.5672	32	564.4919	88	0	TIC	0
33	818.4356	33	415.6538	92	0	TIC	0
34	836.9392	34	600.6314	93	0	TIC	0
35	261.3858	35	1208.118	103	0	TIC	0
36	494.0558	36	1441.341	104	0	TIC	0
37	1321.059	37	568.7632	109	0	TIC	0
38	384.36	38	449.4869	119	0	TIC	0
39	290.1904	39	1779.905	120	0	TIC	0
40	661.2987	40	806.0221	121	0	TIC	0
41	595.6647	41	512.5543	129	0	TIC	0
42	755.9113	42	514.2823	134	0	TIC	0
43	899.1519	43	1043.013	135	0	TIC	0
44	453.5926	44	521.5839	138	0	TIC	0
45	634.0077	45	885.7885	140	0	TIC	0
46	583.4763	46	525.6437	141	0	TIC	0
47	828.5286	47	838.5959	142	0	TIC	0
48	838.5959	48	828.5286	146	0	TIC	0
49	525.6437	49	583.4763	150	0	TIC	0
50	885.7885	50	634.0077	163	0	TIC	0
51	521.5839	51	453.5926	167	0	TIC	0
52	1043.013	52	899.1519	168	0	TIC	0
53	514.2823	53	755.9113	173	0	TIC	0
54	512.5543	54	595.6647	174	0	TIC	0
55	806.0221	55	661.2987	177	0	TIC	0
56	1779.905	56	290.1904	181	0	TIC	0
57	449.4869	57	384.36	182	0	TIC	0
58	568.7632	58	1321.059	186	0	TIC	0
59	1441.341	59	494.0558	191	0	TIC	0
60	1208.118	60	261.3858	192	0	TIC	0
61	600.6314	61	836.9392	195	0	TIC	0
62	415.6538	62	818.4356	206	0	TIC	0
63	564.4919	63	763.5672	224	0	TIC	0
64	782.319	64	987.7182	227	0	TIC	0
65	689.1867	65	557.3997	238	0	TIC	0
66	820.2217	66	716.968	242	0	TIC	0
67	671.8634	67	586.8982	244	0	TIC	0
68	1008.663	68	833.4152	247	0	TIC	0
69	849.5798	69	477.9953	251	0	TIC	0
70	759.9381	70	457.2244	264	0	TIC	0
71	940.429	71	958.5364	268	0	TIC	0
72	988.9039	72	776.547	269	0	TIC	0
73	1123.004	73	485.5323	280	0	TIC	0
74	321.6461	74	330.0897	283	0	TIC	0
75	1045.906	75	528.7451	284	0	TIC	0
76	1387.747	76	807.856	289	0	TIC	0
77	1238.206	77	759.9144	290	0	TIC	0
78	771.8561	78	493.5103	294	0	TIC	0
79	636.386	79	487.4591	305	0	TIC	0
80	871.9394	80	610.7433	156	0	TIC	0
81	679.4526	81	750.0558	58	0	TIC	0
82	254.7551	82	991.4291	59	0	TIC	0
83	840.6456	83	481.9335	185	0	TIC	0
84	2006.711	84	654.7578	100	0	TIC	0
85	734.2972	85	594.1069	133	0	TIC	0
86	830.3489	86	2422.77	27	0	TIC	0
87	1265.95	87	894.2425	183	0	TIC	0
88	1175.198	88	673.9501	48	0	TIC	0
89	747.3561	89	125.5218	39	0	TIC	0
90	1557.776	90	1279.404	66	0	TIC	0
91	544.1751	91	240.1128	54	0	TIC	0
92	763.7603	92	461.7622	56	0	TIC	0
93	1120.856	93	133.065	238	0	TIC	0
94	897.5004	94	511.4795	112	0	TIC	0