Results 1 to 5 of 5

Double lookup in multi column table

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    Double lookup in multi column table

    I have table of Sales reps and corresponding bonus structure for each person. Each rep is payed a bonus based on amount of sales. The bonus for reach Tier 1 is $5,000; the bonus for reaching Tier 2 is $50,000. The issue is each rep must achieve a different level of total sales to reach tier 1 and tier 2. I have attached a sample spreadsheet with actual sales for each rep and expected bonus for each. Thanks in advance for any comments.
    Attached Files Attached Files

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