Spreadsheet: 545488d1509494006-final-salary-to-show-in-a-different-cell-final-payout-to-be-placed-in-a-different-sheet
Sheet: Calculator

 | Sales_Person | [NAME]
 | Attainment | Appointments Completed | QA | Successful Sales |  |  |  | 0 | 100 | 125 | 150 | 175 | 225 | 275 | 300 | 350 | 400 | 500
 | 1 |  |  |  |  |  |  | Goal | Tier 1 | [NAME] | Tier 3 | [NAME] | Tier 5 | Tier 6 | Tier 7 | Tier 8 | Tier 9 | Tier 10
 |  | 0.5 | 35%% | 0 |  |  |  | 1 | 101%-109% | 110%-119% | 120%-129% | 130%-139% | 140%-149% | 150%-165% | 166%-180% | 181%-200% | 201%-299% | 300%-399%
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If the Attainment Score ranges from 0% to 100.99%, the Performance Bonus is $0.00. From 101% to 109.99%, Performance Bonus is $100.00. From 110% to 119.99%, the bonus is $125.00. If it's 120% to 129.99%, bonus is $150.00.
 | $$$     ATTAINMENT CALCULATOR    $$$
 | Appointments Completed |  | 90
 | QA
 |  |  |  |  |  |  |  | YOUR ATTAINMENT SCORE IS |  |  |  |  | YOUR PERFORMANCE BONUS IS |  |  |  |  |  | 3 | 3.99 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.01 | 2.99 |  | 400
 | Successful Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.81 | 2 |  | 350
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.66 | 1.8 |  | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 1.65 |  | 275
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.4 | 1.49 |  | 225
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.3 | 1.39 |  | 175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2 | 1.29 |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1 | 1.19 |  | 125
 |  |  |  |  |  |  |  |  |  | How can I show the proper Performance Bonus (W column) in N18 for its respective Attainment Score (COLUMNS T and U) they got from J18? |  |  |  |  |  |  |  |  | 1.01 | 1.09 |  | 100
 |  |  |  |  |  |  |  |  |  | If example [NAME] gained 130.91% for his Attainment score, then the corresponding Performance Bonus is $175.00. I like it to show in N18 |  |  |  |  |  |  |  |  | 0 | 1 |  | 0
 |  |  |  |  |  |  |  |  |  | I tried the formula =INDEX(W15:W25,MATCH(TRUE,V15:V25,0)), when the attainment score is 214.91%, the "YOUR PERFORMANCE SCORE IS" gets an #N/A.  It should get the value of $400.00, getting the value from W column.
 |  |  |  |  |  |  |  |  | Preferred Results
 |  |  |  |  |  |  |  | YOUR ATTAINMENT SCORE IS |  |  |  |  | YOUR PERFORMANCE BONUS IS |  |  |  |  |  | RANGE |  |  | BONUS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3.9999 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.01 | 2.9999 |  | 400
 |  |  |  |  |  |  |  |  | 2.1491 |  |  |  | 400 |  |  |  |  |  | 1.81 | 2.0099 |  | 350
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.66 | 1.8099 |  | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 1.6599 |  | 275
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.4 | 1.4999 |  | 225
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.3 | 1.3999 |  | 175
 |  |  |  |  |  |  |  |  | If Attainment score falls between 0% to 100.99%, Performance Bonus should show as $0.00. If between 101% to 109.99%, bonus should be $100. If between 110% to 119.99%, bonus is $125. If Attainment is between 120% to 129.99%, bonus should be $150. Say for the above example, the attainment score is 214.91%, the Performance is $400 since it falls between the range of 201% to 299.99%. |  |  |  |  |  |  |  |  |  | 1.2 | 1.2999 |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1 | 1.1999 |  | 125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.01 | 1.0999 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1.0099 |  | 0