Need help with this grading sheet using vlookup

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,990
score%grade
17.5fail#####
20failmytable
22.5fail
25fail
27.5fail0fail
30fail40cond fail
32.5fail50unsat
35fail66sat
37.5fail78good
40cond fail90v good
42.5cond fail96exc
45cond fail#####100exc
47.5cond failVLOOKUP(A2,mytable,2)
50unsat
52.5unsat
55unsat
57.5unsat
60unsat
62.5unsat
65unsat
67.5sat
70sat
72.5sat
75sat
77.5sat
80good
82.5good
85good
87.5good
90v good
92.5v good
95v good
97.5exc
100exc

<colgroup><col width="64" span="17" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Forum statistics

Threads
1,086,235
Messages
5,388,623
Members
402,127
Latest member
Jemx

Some videos you may like

This Week's Hot Topics

Top