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 |
+-------------------------------------------------------------------+

--
zelus
------------------------------------------------------------------------
zelus's Profile: http://www.excelforum.com/member.php...o&userid=34510
View this thread: http://www.excelforum.com/showthread...hreadid=542752

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)


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=542752

thanks for your help!


--
zelus
------------------------------------------------------------------------
zelus's Profile: http://www.excelforum.com/member.php...o&userid=34510
View this thread: http://www.excelforum.com/showthread...hreadid=542752