+ Reply to Thread
Results 1 to 3 of 3

Assigning a points scoring system

  1. #1
    Registered User
    Join Date
    05-16-2006
    Posts
    2

    Assigning a points scoring system

    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
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-23-2006
    Location
    Vancouver
    Posts
    114
    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)

  3. #3
    Registered User
    Join Date
    05-16-2006
    Posts
    2
    thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1