Match Index array formula

[vmjan02]

I am not getting the desired out with this array formula (Column D is phone num, Column G is count, column H is D&C, column J is amount

{=IF((Sheet2!$D$5:$D$800000>=$B$3)*(Sheet2!$G$5:$G$800000<=$D$2)*(Sheet2!$H$2:$H$800000=$B$3&$D$2),Sheet2!$J$5:$J$80000)}

In sheet1 it should search B3 (phonenumber) and D2 (count) and should show the amount.


[TABLE="width: 357"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Phon[/TD]
[TD]StID[/TD]
[TD] Country [/TD]
[TD]Count [/TD]
[TD] Phone[/TD]
[TD] CR[/TD]
[TD] Amot[/TD]
[/TR]
[TR]
[TD="align: right"]9768146004[/TD]
[TD="align: right"] 370 [/TD]
[TD] US[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"] 97681460041[/TD]
[TD] XX [/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5000[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

B3 is the user search value (search from column D) and d3 is 1 (search from column G)

What does that 1 means as I don't see how that would contribute as a condition?