Sliding scale with dependencies

[rp83]

Hi, I am running into an issue calculating a sliding scale. I have number of dependencies on the scale, see attached but here is the brief.

Employee achieves 95.31% of revenue targets
Employee achieves - Achieve rating on behaviour (more info on attached)
Based on revenue achievement of 95.31%, I need to look up payout % based on Achieved rating (more info on attached)

Any help will be much appreciated.

Thanks

[samba_ravi]

try below formula in I7

Please Login or Register  to view this content.

[rp83]

Thank you! Since posting, with breaking the formulae down in 4 different columns, I had found the solution but you formulae just looks much more professional! Thanks !!