Assigning a points scoring system

[zelus]

HI

New user to this forum and after some help on my attached file.

I want to assign a points scoring system to my sales staff.
In column E i have the sales person's average units per sale. I have a
table to far right with a scoring system based on there units per
sale.

Can i insert a formula in column F that will assign the proper point
score the the salespersons unit per sale result.

Thanks for your help


+-------------------------------------------------------------------+
|Filename: Sales Net of.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4773 |
+-------------------------------------------------------------------+

 

[CaptainQuattro]

Column j is not needed. If you delete it you can use the following
formula

Assuming Brian is in Row 7:

In Cell F7 enter

=vlookup(E7,$I:$J,2,TRUE)

 

[zelus]

thanks for your help!