Hello,
I've been trying to use IF and INDEX/MATCH for my issue but to no avail. I honestly need to use INDEX/MATCH for this problem since the real productivity table has a couple of columns in between.
The target scores are ranged; I need the ACTUAL PROD TABLE to convert to single digit scores on the SCORECARD TABLE based on the targets in the SCORECARD GUIDE TABLE. Please see attached.
Thank you!
Bookmarks