LOOKUP
I'm sure I know how to do this but its not working
For every week people get performance rated, ie 1 for good, 0 for bad. I
have a table for this information.
What I want to do it use the following table to apply performance % for qtr.
Score
13 100%
12 80%
11 60%
10 40%
9 20%
8 0%
7 0% and so on.
I have tried using a sum to add the ones, and then a VLOOKUP, but it doesn't
work!! HELP!
|