change value in roll as the column sum changes using data from a table.

[rafcaf]

I have the following data:

a b b c d e f
1-Jan-15 22.48 15.89 17.45 21.11 16.71
1-Feb-15 15.05 18.49 6.21 5.47 15.74
1-Mar-15 5.67 2.44 5.27 8.01 16.15 16.71
1-Apr-15
1-May-15

43.2 28.33 23.76 31.67 42.73 49.16

Rank 5 7 7 6 5 5


Score Table
low high Score

0 9.99 NA
10 19.99 8
20 29.99 7
30 39.99 6
40 49.99 5
50 59.99 4
60 69.99 3
70 70.99 2
80 89.99 1

as the sums for the columns increase, I need the rank roll to change according to the new sum using the Score table. My actual spread sheet has 31 columns. I really do not want to use a bunch of embedded if statements or a bunch of embedded "and" statements.updating score rank.xlsx

[Debraj Roy]

Hi ..

Welcome to the forum..

In B13.. use formula as

Please Login or Register  to view this content.

[rafcaf]

Thank you ever so much. I tried using lookup but could not get them to work. I guess I really need to study lookup more. Again, thank you and have a great weekend.

[Debraj Roy]

Glad that it works for you..

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.