Thread
:
LOOKUP
View Single Post
#
1
Gary Brown
Posts: n/a
LOOKUP
Assumptions...
Employee:
Week - A1:A12
Score - B1:B12
Table:
Score - G1:G15
Percentage - H1:H15
Formula for lookup -
=VLOOKUP(SUM($B$2:$B$12),$G:$H,2,FALSE)
HTH,
--
Gary Brown
"Natalie" wrote:
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!
Reply With Quote