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:
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.
Thank you
Bookmarks