Spreadsheet: 48255d1247502529-vlookup-problem-vlookup
Sheet: Insert Data(Column A- Column D)

C | F | X | P
005 | 21467 | 13 | 605.58
006 | 5057 | 1 | 197.75
0106 | 1 | 0 | 0
0210 | 7812 | 59 | 7552.48
0310 | 2032 | 0 | 0
0350 | 1651 | 137 | 82980.01
0501 | 8795 | 8 | 909.61
0502 | 18094 | 4 | 221.07
0503 | 28730 | 1 | 34.81
0504 | 43496 | 15 | 344.86
0505 | 17805 | 1 | 56.16
0511 | 36 | 0 | 0
0601 | 29363 | 7 | 238.40
0602 | 10722 | 83 | 7741.09
0603 | 84965 | 5 | 58.85
0604 | 70902 | 28 | 394.91
0605 | 9752 | 2 | 205.09
0701 | 395 | 0 | 0
0708 | 11155 | 4 | 358.58
0709 | 9754 | 20 | 2050.44
0710 | 9964 | 8 | 802.89
0711 | 2185 | 6 | 2746.00
0712 | 2521 | 0 | 0
0713 | 25094 | 5 | 199.25
0714 | 314 | 3 | 9554.14
0715 | 9295 | 0 | 0
0716 | 17753 | 0 | 0
0718 | 1907 | 55 | 28841.11
0719 | 6332 | 13 | 2053.06
0720 | 864 | 8 | 9259.26
0721 | 7894 | 23 | 2913.61
0722 | 71 | 0 | 0
0723 | 194 | 0 | 0
0724 | 57 | 1 | 17543.86
0728 | 2355 | 11 | 4670.91
0730 | 92 | 0 | 0
0731 | 32 | 0 | 0
0735 | 1170 | 2 | 1709.40
0736 | 131 | 0 | 0
0800 | 2195 | 0 | 0
0831 | 1204 | 0 | 0
0901 | 182 | 1 | 5494.51
0902 | 242 | 5 | 20661.16
0904 | 3124 | 4 | 1280.41
0905 | 3998 | 2 | 500.25
0906 | 538 | 2 | 3717.47
0908 | 1957 | 5 | 2554.93
0910 | 829 | 9 | 10856.45
1000 | 7913 | 11 | 1390.12
1001 | 1173 | 0 | 0
1002 | 3049 | 0 | 0
1003 | 3084 | 6 | 1945.53
1004 | 5373 | 5 | 930.58
1100 | 0 | 13
1150 | 25487 | 8 | 313.89
1151 | 17902 | 34 | 1899.23
1152 | 7017 | 28 | 3990.31
1153 | 2501 | 42 | 16793.28
1154 | 3027 | 10 | 3303.60
1155 | 509 | 0 | 0
1156 | 7752 | 15 | 1934.98
1157 | 2558 | 9 | 3518.37
1158 | 88 | 8 | 90909.09
1159 | 2116 | 17 | 8034.03
1160 | 168 | 37 | 220238.10
1180 | 0 | 9
1400 | 606 | 2 | 3300.33
1500 | 505 | 4 | 7920.79
1600 | 36 | 0 | 0
1700 | 203 | 14 | 68965.52
1701 | 180 | 0 | 0
1702 | 269 | 0 | 0
1703 | 0 | 1
1750 | 235 | 14 | 59574.47
1775 | 9523 | 0 | 0
1800 | 196 | 0 | 0
1850 | 9644 | 0 | 0
1900 | 51882 | 0 | 0
2001 | 4223 | 3 | 710.40
2002 | 2036 | 1 | 491.16
2003 | 2706 | 3 | 1108.65
2004 | 3843 | 4 | 1040.85
2005 | 10350 | 0 | 0
2100 | 3644 | 10 | 2744.24
2200 | 63284 | 0 | 0
2201 | 747 | 11 | 14725.57
2250 | 32771 | 0 | 0
2500 | 221 | 0 | 0
2600 | 16831 | 28 | 1663.60
2601 | 1425 | 3 | 2105.26
2602 | 1579 | 0 | 0
2603 | 206 | 0 | 0
2604 | 9 | 0 | 0
2725 | 0 | 0 | 0
3100 | 0 | 1
3700 | 0 | 50
3950 | 0 | 37
4200 | 0 | 13
4300 | 11918 | 184 | 15438.83
8001 | 67 | 0 | 0
9000 | 0 | 4
MO-02 | 6901 | 30 | 4347.20
MO-03 | 0 | 41
MO-04 | 3955 | 131 | 33122.63
MO-05 | 802 | 2 | 2493.77
MO-06 | 2209 | 9 | 4074.24
MO-07 | 2181 | 15 | 6877.58
MO-08 | 3134 | 19 | 6062.54
MO-09 | 2253 | 6 | 2663.12
MO-10 | 6019 | 34 | 5648.78
MO-11 | 678 | 1 | 1474.93
MO-12 | 1906 | 123 | 64533.05
MO-13 | 7750 | 44 | 5677.42
MO-14 | 8079 | 22 | 2723.11
MO-15 | 11852 | 354 | 29868.38
MO-16 | 5870 | 7 | 1192.50
MO-18 | 4061 | 12 | 2954.94
MO-19 | 10490 | 40 | 3813.16
MO-20 | 12339 | 38 | 3079.67
MO-21 | 3508 | 19 | 5416.19
MO-22 | 9468 | 36 | 3802.28
MO-23 | 3011 | 30 | 9963.47
MO-24 | 3409 | 22 | 6453.51
MO-25 | 394 | 0 | 0
MO-26 | 2176 | 8 | 3676.47
MO-27 | 5818 | 7 | 1203.16
MO-28 | 2079 | 8 | 3848.00
MO-29 | 2126 | 20 | 9407.34
MO-30 | 5060 | 26 | 5138.34
[NAME] | 34033 | 84 | 2468.19
MO-32 | 1397 | 1 | 715.82
MO-33 | 1067 | 8 | 7497.65
mo-34 | 722 | 11 | 15235.46
MO-36 | 3050 | 20 | 6557.38
MO-38 | 4153 | 8 | 1926.32
MO-40 | 836 | 8 | 9569.38
MO-41 | 1701 | 2 | 1175.78
MO-42 | 634 | 6 | 9463.72
MO-43 | 5261 | 15 | 2851.17
MO-44 | 6261 | 81 | 12937.23
MO-45 | 1779 | 10 | 5621.14
MO-46 | 4090 | 27 | 6601.47
MO-47 | 3950 | 10 | 2531.65
MO-48 | 1824 | 13 | 7127.19
MO-50 | 3222 | 28 | 8690.25
MO-52 | 1877 | 6 | 3196.59
MO-53 | 6463 | 48 | 7426.89
MO-54 | 1613 | 10 | 6199.63
MO-55 | 1496 | 6 | 4010.70
[NAME] | 5181 | 13 | 2509.17
MO-57 | 2838 | 29 | 10218.46
[NAME] | 2458 | 53 | 21562.25
MO-59 | 2008 | 7 | 3486.06
MO-60 | 4417 | 191 | 43242.02
MO-61 | 2015 | 13 | 6451.61
MO-63 | 2115 | 1 | 472.81
MO-66 | 1320 | 22 | 16666.67
MO-67 | 3230 | 1 | 309.60
MO-68 | 10065 | 149 | 14803.78