stewstew03
New Member
- Joined
- Mar 4, 2014
- Messages
- 5
Hi,
I'd like to pull in the appropriate salary data based on a person's current salary. The goal is to pull that person's salary up to the next step in the salary structure. So if they are currently making $50,000, then they should be making $50,980 (Step 7 in the appropriate salary structure). Any assistance would be appreciated.
<tbody>
</tbody><colgroup><col><col span="2"><col><col><col><col></colgroup>
<tbody>
</tbody>
Here are the lookup data:
<tbody>
</tbody>
I'd like to pull in the appropriate salary data based on a person's current salary. The goal is to pull that person's salary up to the next step in the salary structure. So if they are currently making $50,000, then they should be making $50,980 (Step 7 in the appropriate salary structure). Any assistance would be appreciated.
Job Title | Structure | Grade | Concatenate | Current Salary | New Salary | |
Accountant | Primary | F | Primary-F | $50,000 | ? | <---$50,980 |
Nurse | Medical | A | Medical-A | $67,800 | ? | <---$69,301 |
Business Analyst | Tech | C | Tech-C | $76,500 | ? | <---Max |
<tbody>
</tbody><colgroup><col><col span="2"><col><col><col><col></colgroup>
<tbody>
</tbody>
Here are the lookup data:
Pay Grade | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8 | Step 9 | Step 10 | Step 11 | Step 12 |
Primary-F | $43,812 | $45,006 | $46,201 | $47,396 | $48,590 | $49,785 | $50,980 | $52,174 | $53,369 | $54,564 | $55,759 | $56,953 |
Medical-A | $65,717 | $67,509 | $69,301 | $71,093 | $72,886 | $74,678 | $76,470 | $78,262 | $80,054 | $81,846 | $83,638 | $85,430 |
Tech-C | $56,955 | $58,508 | $60,061 | $61,614 | $63,167 | $64,721 | $66,274 | $67,827 | $69,380 | $70,933 | $72,486 | $74,039 |
<tbody>
</tbody>