Unable to solve #NA error in excel while using VLOOKUP

[prashant_0786]

I am having a data sheet in excel. I am using vlookup in this data with table array in other sheet. However I am getting #NA error in vlookup formula.
I have cleaned my data by many ways using test converter, multiplier etc. but all failed. please help me to resolve this.

test-Vlookup-upload.XLSX
	B	C	D	E	F	G
1		Purchase Order	Tender No	OLD Purchase Order	Diff	Purchase Order
2	0	4510001024	T-12	4510001024	0	4510001024
3	#N/A	4510001024	T-12	4510001024	0	4510001024
4		4510001027	T-12	4510001027	0	4510001027
5		4510001027	T-12	4510001027	0	4510001027
6		4510001027	T-12	4510001027	0	4510001027
7		4510001027	T-12	4510001027	0	4510001027
8		4510001027	T-12	4510001027	0	4510001027
9		4510001027	T-12	4510001027	0	4510001027
10		4510001027	T-12	4510001027	0	4510001027
11		4510001027	T-12	4510001027	0	4510001027
12		4510001031	T-12	4510001031	0	4510001031
13		4510001031	T-12	4510001031	0	4510001031
14		4510001066	T-12	4510001066	0	4510001066
15		4510001066	T-12	4510001066	0	4510001066
16		4510001066	T-12	4510001066	0	4510001066
17		4510001066	T-12	4510001066	0	4510001066
18		4510001066	T-12	4510001066	0	4510001066
19		4510001066	T-12	4510001066	0	4510001066
20		4510001066	T-12	4510001066	0	4510001066
21		4510001066	T-12	4510001066	0	4510001066
22		4510001066	T-12	4510001066	0	4510001066
23		4510001066	T-12	4510001066	0	4510001066
24		4510001066	T-12	4510001066	0	4510001066
25		4510000808	T-10	4510000808	0	4510000808
26		4510000828	T-10	4510000849	-21	4510000828
27		4510000828	T-10	4510000849	-21	4510000828
28		4510000828	T-10	4510000849	-21	4510000828
Sheet1 (2)

Cell Formulas
Range	Formula
B2	B2	=VLOOKUP(G2,Sheet4!B1:C187,1,1)
B3	B3	=VLOOKUP(C3,D3:E3,1,0)
F2:F28	F2	=G2-E2

Array table

test-Vlookup-upload.XLSX
	A	B	C
2	1	T-09	4510000782
3	2	T-09	4510000857
4	3	T-09	4510000890
5	4	T-09	4510000922
6	5	T-09	4510000783
7	6	T-09	4510000856
8	7	T-09	4510000889
9	8	T-09	4510000921
10	9	T-09	4510000953
11	10	T-09	4510001069
12	11	T-09	4510000873
13	12	T-10	4510000853
14	13	T-10	4510000800
15	14	T-10	4510000850
16	15	T-10	4510000893
17	16	T-10	4510000917
18	17	T-10	4510000799
19	18	T-10	4510000848
20	19	T-10	4510000892
21	20	T-10	4510000916
22	21	T-10	4510000801
23	22	T-10	4510000852
24	23	T-10	4510000895
25	24	T-10	4510000918
26	25	T-10	4510000807
27	26	T-10	4510000872
28	27	T-10	4510000896
29	28	T-10	4510000802
30	29	T-10	4510000854
31	30	T-10	4510000897
32	31	T-10	4510000914
33	32	T-10	4510000803
34	33	T-10	4510000855
35	34	T-10	4510000899
36	35	T-10	4510000920
37	36	T-10	4510000780
38	37	T-10	4510000851
39	38	T-10	4510000894
40	39	T-10	4510000909
41	40	T-10	4510000808
42	41	T-10	4510000849
43	42	T-10	4510000891
44	43	T-10	4510000915
45	44	T-10	4510000809
46	45	T-10	4510000858
47	46	T-10	4510000898
48	47	T-10	4510000919
49	48	0	4510000825
50	49	T-11	4510000821
51	50	T-11	4510000822
52	51	T-11	4510000947
53	52	T-11	4510000971
54	53	T-11	4510000990
55	54	T-11	4510001046
56	55	T-12	4510000841
57	56	T-11	4510000824
58	57	T-11	4510000980
59	58	T-11	4510001044
60	59	T-11	4510000823
61	60	T-11	4510000994
62	61	T-11	4510001006
63	62	T-11	4510001039
64	63	T-11	4510001045
65	64	T-11	4510000826
66	65	T-11	4510001005
67	66	T-11	4510001043
68	67	T-12	4510000846
69	68	T-12	4510000923
70	69	T-12	4510000944
71	70	T-12	4510000967
72	71	T-12	4510000992
73	72	T-12	4510000998
74	73	T-12	4510000838
75	74	T-12	4510000976
76	75	T-12	4510000977
77	76	T-12	4510000978
78	77	T-12	4510001429
79	78	T-12	4510000837
80	79	T-12	4510000972
81	80	T-12	4510000844
82	81	T-12	4510000941
83	82	T-12	4510000997
84	83	T-12	4510001047
85	84	T-12	4510000832
86	85	T-12	4510000966
87	86	T-12	4510000970
88	87	T-12	4510000829
89	88	T-12	4510001025
90	89	T-12	4510000831
91	90	T-12	4510000995
92	91	T-12	4510000996
93	92	T-12	4510001019
94	93	T-12	4510000828
95	94	T-12	4510000958
96	95	T-12	4510000993
97	96	T-12	4510001024
98	97	T-12	4510001031
99	98	T-12	4510001066
100	99	T-12	4510000842
101	100	T-12	4510000957
102	101	T-12	4510000991
103	102	T-12	4510001020
104	103	T-12	4510001036
105	104	T-12	4510000982
106	105	T-12	4510001026
107	106	T-12	4510001034
108	107	T-12	4510001042
109	108	T-12	4510001070
110	109	T-12	4510000839
111	110	T-12	4510000827
112	111	T-12	4510000959
113	112	T-12	4510000987
114	113	T-12	4510000988
115	114	T-12	4510001037
116	115	T-12	4510001028
117	116	T-12	4510000843
118	117	T-12	4510000961
119	118	T-12	4510001018
120	119	T-12	4510000845
121	120	T-12	4510000946
122	121	T-12	4510001038
123	122	T-12	4510000847
124	123	T-12	4510000948
125	124	T-12	4510000960
126	125	T-12	4510000979
127	126	T-12	4510001035
128	127	T-12	4510001071
129	128	T-12	4510000840
130	129	T-12	4510000940
131	130	T-12	4510000830
132	131	T-12	4510001009
133	132	T-12	4510001010
134	133	T-12	4510001011
135	134	T-12	4510001012
136	135	T-12	4510001013
137	136	T-12	4510001014
138	137	T-12	4510001015
139	138	T-02	4510001278
140	139	T-02	4510001090
141	140	T-01	4510001085
142	141	T-01	4510001193
143	142	T-01	4510001116
144	143	T-01	4510001141
145	144	T-01	4510001110
146	145	T-01	4510001072
147	146	T-01	4510001091
148	147	T-01	4510001103
149	148	T-01	4510001073
150	149	T-01	4510001092
151	150	T-01	4510001088
152	151	T-01	4510001137
153	152	T-01	4510001114
154	153	T-02	4510001161
155	154	T-02	4510001033
156	155	T-02	4510001156
157	156	T-02	4510001142
158	157	T-02	4510001162
159	158	T-02	4510001179
160	159	T-02	4510001084
161	160	T-02	4510001322
162	161	T-01-EO	4510001455
163	162	T-01-EO	4510001474
164	163	T-01-EO	4510001463
165	164	T-01-EO	4510001464
166	165	T-01-EO	4510001449
167	166	T-01-EO	4510001476
168	167	T-02-EO	4510001477
169	168	T-02-EO	4510001478
170	169	T-02-EO	4510001456
171	170	T-02-EO	4510001461
172	171	T-02-EO	4510001450
173	172	T-02-EO	4510001465
174	173	T-02-EO	4510001466
175	174	T-01-EO	4510001462
176	175	T-01-EO	4510001475
177	176	T-01-EO	4510001454
178	177	T-04-1020	4510001526
179	178	T-04-1020	4510001529
180	179	T-04-1020	4510001532
181	180	T-03-1020	4510001523
182	181	T-03-1020	4510001524
183	182	T-03-1020-25	4510001522
184	183	T-03-1020	4510001525
185	184	T-03-1020-16	4510001543
186	185	T-03-1020	4510001544
187	186	T-03-1020	4510001539
Sheet4

 

[Fluff]

You have the wrong ranges in your vlookups.
B2 should be

=VLOOKUP(G2,Sheet4!C1:C187,1,1)

 

[Peter_SSs]

Hard to know exactly what you are trying to do.

Your formula in B2 is looking for 4510001024 in column B of Sheet4. That number does not exist in that column.
Your formula in B3 is looking for 4510001024 in column D of Sheet1 (2). That number does not exist in that column.