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.
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
{=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.
Phon | StID | Country | Count | Phone | CR | Amot |
9768146004 | 370 | US | 1 | 97681460041 | XX | 200 |
300 | ||||||
400 | ||||||
5000 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>