How do you provide points based on a defined lookup targets table

Originally Posted by HansDouwe

Both my formula and Windknife's formula do not take this situation into account, because it was not included in your test set.
It must be clear which degrees of freedom are possible.

I don't have time today, but will make a solution for this tomorrow.
I already know how I want to handle that.

Apologies I wasn't clear about that, really appreciate help so far and must be honest while both formulas are complex, I can follow yours a little more, but I can see what ever is the final working solution is going to require me to do a lot of research understand, which is a good thing