2 axis scale using INDEX,SUMPRODUCT, and <> functions

[Clooney]

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]So I Have 3 sheets "Scale", "Incentive Calcs", and "Data"[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]What I am trying to do here is to get a $/Direct value from Column R in sheet "Scale" into the sheet "Incentive Calcs", Column I based on each row's values from Columns G and H.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Example formula from Cell I2 is this: =INDEX(Scale!$R$19:$R$278,SUMPRODUCT(('Incentive Calcs'!G2>Scale!$P$19:$P$278),--('Incentive Calcs'!G2<scale!$q$19:$q$278),--('incentive calcs'!h2="">Scale!$N$19:$N$278),--('Incentive Calcs'!H2<scale!$o$19:$o$278),row(scale!$al$1:$al$278)))< td=""></scale!$o$19:$o$278),row(scale!$al$1:$al$278)))<></scale!$q$19:$q$278),--('incentive>[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Currently this formula is resulting in #VALUE[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]On Sheet "Scale" is the tables and on sheet "Data" is just merely the reference for sheet "Incentive Calcs"[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Column I for "Incentive Calcs" is the issue here and once I can get these values to properly populate, the rest of the sheet will align itself.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]I inherited this from someone else and would like the expertise of this community to help me solve it, though I am unsure of how to attach the workbook so that you all can help me.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Thank you[/TD]
[/TR]
</tbody>[/TABLE]