Spreadsheet: 837586d1690275873-how-do-you-provide-points-based-on-a-defined-lookup-targets-table-points-based-on-value-working-generic-2
Sheet: Test (2)

Only Works in 365
 | Test | Pts | Points Want |  | Test2 | Pts | Points want |  | Test3 | Pts | Points want |  | Test4 | Pts | Points want
[NAME] | 0.2285714285714286 |  | 0 |  | 28 |  | 10 |  | 110 |  | 10 |  | 650 |  | 10
[NAME] | 0.1568627450980392 | 2 | 2 |  | 30 | 10 | 10 |  | 72 | 5 | 5 |  | 651 | 5 | 5
[NAME] | 0.0967741935483871 | 10 | 10 |  | 35 | 5 | 5 |  | 35 | 0 | 0 |  | 696 | 2 | 2
[NAME] | 0.2051282051282051 | 0 | 0 |  | 20 | 10 | 10 |  | 100 | 10 | 10 |  | 750.1 | 0 | 0
[NAME] | 0.06521739130434782 | 10 | 10 |  | 10 | 10 | 10 |  | 46 | 2 | 2 |  | 750 | 2 | 2
[NAME] |  | 0 |  |  | 5 | 10 | 10 |  | 5 | 0 | 0 |  | 550 | 10 | 10
Area2 | 0.09302325581395349 | 10 | 10 |  | 20 | 10 | 10 |  | 110 | 10 | 10 |  | 755 | 10 | 10
Area2 | 0.09090909090909091 | 10 | 10 |  | 30 | 7 | 7 |  | 60 | 7 | 7 |  | 850 | 7 | 7
Area2 | 0.15 | 7 | 7 |  | 15 | 10 | 10 |  | 35 | 1 | 1 |  | 900 | 1 | 1
Area2 | 0.19 | 4 | 4 |  | 35 | 4 | 4 |  | 20 | 0 | 0 |  | 1001 | 0 | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0