[TABLE="width: 400"]
NO
A
B
C
D
E
F
G
H
1
111
100000
111
450
2
222
200000
222
500
3
333
300000
333
640
4
444
400000
111
687
5
555
500000
444
5690
6
666
600000
555
4569
7
777
700000
111
7890
8
888
800000
999
26460
9
999
900000
777
5426
10
888
2564
11
111
56987
12
111
560
13
222
400
14
111
6980
15
555
578
16
111
300
17
18
19
[/TABLE]
[TABLE="width: 70"]
Codition 1=
[TABLE="width: 233"]
[TD="class: xl65, width: 233, colspan: 3"]SUMPRODUCT((G:G=G2)*(H:H))<B2
[/TABLE]
[/TD]
Codition 2=
[TABLE="width: 479"]
[TD="class: xl66, width: 479, colspan: 6"]SUMPRODUCT((G:G=G2)*(H:H))<INDEX($A$2:$E$10,MATCH(G2,G:G,0),2)
[/TABLE]
[/TD]
Codition 3=
[TABLE="width: 479"]
[TD="class: xl66, width: 479, colspan: 6"]SUMPRODUCT((G:G=G2)*(H:H))<VLOOKUP(G2,A:E,2,FALSE)
[/TABLE]
[/TD]
Codition 4=
[TABLE="width: 479"]
[TD="class: xl66, width: 479, colspan: 6"]SUMPRODUCT((G:G=G2)*(H:H))<150000
[/TABLE]
[/TD]
[/TABLE]
[TABLE="width: 896"]
[TD="colspan: 4"]I m trying to validate data in Column H.
[/TD]
[TD="colspan: 14"]when I put code in column G and amount In column H, it should not exceed amount 100000 because A2 and B2 validate code and amount[/TD]
[TD="colspan: 3"]reference code 111
[TABLE="width: 512"]
[TD="colspan: 8"]Condition 4 did OK but all seems right, I need condition 2 to be right.
[/TD]
[/TABLE]
[/TD]
[/TABLE]