Spreadsheet: 681366d1591530145-need-vlookup-or-something-else-that-outputs-value-based-on-closest-match-vlookup-based-on-closed-found-match
Sheet: Sheet1

NORMALIZED VALUE | Simple Vlookup |  | CRITERIA SCORE | SCORE
0 |  |  | 0 | 10
1 |  |  | 0.1 | 9
0 |  |  | 0.2 | 8
0.3333333333333333 |  |  | 0.3 | 7
0.6666666666666666 |  |  | 0.4 | 6
1 |  |  | 0.5 | 5
0 |  |  | 0.6 | 4
0.2 |  |  | 0.7 | 3
0.4 |  |  | 0.8 | 2
0.6 |  |  | 0.9 | 1
0.8 |  |  | 1
1
0
1
0
1
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
0
0.25
0.5
0.75
1
0
1
0
1
0
0.008771929824561403
0.01754385964912281
0.02631578947368421
0.03508771929824561
0.04385964912280702
0.05263157894736842
0.06140350877192982
0.07017543859649122
0.07894736842105263
0.08771929824561403
0.09649122807017543
0.1052631578947368
0.1140350877192982
0.1228070175438596
0.131578947368421
0.1403508771929824
0.1491228070175439
0.1578947368421053
0.1666666666666667
0.1754385964912281
0.1842105263157895
0.1929824561403509
0.2017543859649123
0.2105263157894737
0.2192982456140351
0.2280701754385965
0.2368421052631579
0.2456140350877193
0.2543859649122807
0.2631578947368421
0.2719298245614035
0.2807017543859649
0.2894736842105263
0.2982456140350877
0.3070175438596491
0.3157894736842105
0.3245614035087719
0.3333333333333333
0.3421052631578947
0.3508771929824561
0.3596491228070176
0.3684210526315789
0.3771929824561404
0.3859649122807017
0.3947368421052632
0.4035087719298245
0.412280701754386
0.4210526315789473
0.4298245614035088
0.4385964912280702
0.4473684210526316
0.456140350877193
0.4649122807017544
0.4736842105263158
0.4824561403508772
0.4912280701754386
0.5
0.5087719298245614
0.5175438596491229
0.5263157894736842
0.5350877192982456
0.543859649122807
0.5526315789473685
0.5614035087719298
0.5701754385964912
0.5789473684210527
0.5877192982456141
0.5964912280701754
0.6052631578947368
0.6140350877192983
0.6228070175438597
0.631578947368421
0.6403508771929824
0.6491228070175439
0.6578947368421053
0.6666666666666666
0.6754385964912281
0.6842105263157895
0.6929824561403509
0.7017543859649122
0.7105263157894737
0.7192982456140351
0.7280701754385965
0.7368421052631579
0.7456140350877193
0.7543859649122807
0.7631578947368421
0.7719298245614035
0.7807017543859649
0.7894736842105263
0.7982456140350878
0.8070175438596491
0.8157894736842105
0.8245614035087719
0.8333333333333334
0.8421052631578947
0.8508771929824561
0.8596491228070176
0.868421052631579
0.8771929824561403
0.8859649122807017
0.8947368421052632
0.9035087719298246
0.9122807017543859
0.9210526315789473
0.9298245614035088
0.9385964912280702
0.9473684210526315
0.956140350877193
0.9649122807017544
0.9736842105263158
0.9824561403508771
0.9912280701754386
1
0
1
0
1
0
0.2
0.4
0.6
0.8
1
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
0
1
0
1
0
1
0
0.0303030303030303
0.06060606060606061
0.09090909090909091
0.1212121212121212
0.1515151515151515
0.1818181818181818
0.2121212121212121
0.2424242424242424
0.2727272727272727
0.303030303030303
0.3333333333333333
0.3636363636363636
0.3939393939393939
0.4242424242424243
0.4545454545454545
0.4848484848484849
0.5151515151515151
0.5454545454545454
0.5757575757575758
0.6060606060606061
0.6363636363636364
0.6666666666666666
0.696969696969697
0.7272727272727273
0.7575757575757576
0.7878787878787878
0.8181818181818182
0.8484848484848485
0.8787878787878788
0.9090909090909091
0.9393939393939394
0.9696969696969697
1
0
0.5
1
0
0.03703703703703703
0.07407407407407407
0.1111111111111111
0.1481481481481481
0.1851851851851852
0.2222222222222222
0.2592592592592592
0.2962962962962963
0.3333333333333333
0.3703703703703703
0.4074074074074074
0.4444444444444444
0.4814814814814815
0.5185185185185185
0.5555555555555556
0.5925925925925926
0.6296296296296297
0.6666666666666666
0.7037037037037037
0.7407407407407407
0.7777777777777778
0.8148148148148148
0.8518518518518519
0.8888888888888888
0.9259259259259259
0.9629629629629629
1