Find value in column A, then take value from column B?

[JJ2k10]

So I've got a group of data like this;

Column A:

123456
643214
592010
234677
123452
324235
623115
235677
272166
336812

Column B:
34.8
23.5
12
24.9
23
42
56
79
21
24

Column C;
336812
123452
324235

ect.

Column A and B are linked, so A2 is linked with B2 (Column B is the price of the product)

and column C's numbers are also in column A somewhere, and I want to match up the prices with column C, so find the value from C in A and copy column B for that certain number. I can use find to do it but I have 200 so it'd take ages

[Chris 53]

In D1 = vlookup(c1,$a$1;$b$1000,2,false)

Copy D1 down.

[JJ2k10]

Thanks, it works for the first 3 rows then it just gives me the #N/A error.

[Special-K]

What are the values in column C?

[Chris 53]

Does the data in column C extend below the first 3 lines?

If it does, are you sure that the data in column C exists in column A?

[JJ2k10]

2480270000
2070800000
1200070000
134111
24497
51174
57030
57031
69509
98635
104458
104694
104720
123997
162285
582068
750804
269189
280499
298796
428540
1736000
2333100
2333200
2333400
2303400
2333500
2333600
2304000
2304100
2304600
2304700
1927800
2409500
2490900
2491000
1403600
1405000
2468800
2211200
2211600
2211700
1003900
1016400
1004100
1003300
800200
851900
800300
801100
800900
2002100
2399700
2439100
1942400
2439500
2046300
2045800
2492000
1942200
1768100
1804600
1767900
2167300
1662800
1749900
2149200
2149300
2149400
2149000
2149100
1807000
1806900
2133600
1418700
249400
1678100
2286400
2319100
1661000
2429600
1907400
1496500
1225100
1547400
1225200
1951100
1195400
2494000
710600
244000
244300
244200
244700
2494100
2493800
2493900
894000
1002400
2068200
1955400
2439200
1688700
2068300
2439600
1002200
1002300
2287200
1745300
1527600
1991300
2470000
1869700
2071200
1870100
2450600
2028100
2028200
2491300
2491500
2492300
2491200
2420500
2491400
2415800
2492400
2491700
2491600
2491800
2491900
2426700
2409600
2409800
2409700
2409900
2470600
1704200
1531500
1533900
130900
132000
2407800
2429300
2429400
2407600
2408700
2408000
2409000
2429500
2408600
2408500
2407500
2408100
2210900
1124900
1338700
1772400
1125000
1972800
1425900
2416000
2470200
2439000
2491100
2439400
138800
139400
139200
138900
139500
139800
143000
1734800
1706800
1744800
2429800
1677800
1755200
1823500
2213700
1922100
2284300
1659900
1995900
1660200
2429700
2185600
2035200
2136600
1976000
1777200
1870600
1777300
1870500
2185700
1976400
1976200
1976300
1976100
2319200
2136700
1976500
2035300
1870800
1870700
1777500
1777400
967400
931700
1030800
968000
557600
558000
557200
633354
627787
633719
633047
630364
630374
650819
628463
650780
633590
633591
631370
650716
632123
632124
656879
667001
650672
656076
662654
651142
651014
662675
630190
631126
631127
633343
633344
629183
651058
667945
633316
633323
629759
630982
633346


Thanks in advance.