So I Have 3 sheets "Scale", "Incentive Calcs", and "Data" |
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. |
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> |
Currently this formula is resulting in #VALUE |
On Sheet "Scale" is the tables and on sheet "Data" is just merely the reference for sheet "Incentive Calcs" |
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. |
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. |
Thank you |
<tbody>
</tbody>