reneev
Board Regular
- Joined
- Apr 26, 2017
- Messages
- 53
I have a spreadsheet with Positions down the side and Steps across the top and the rates in the columns. I need a formula that will pull the rate for the first available step into one column. So for receptionist, it would pull the Step 1 rate, for Technician it would pull the Step 3 rate and for Office Manager it would pull the Step 6 rate.
I need to be able to vlookup the first step rate for the position into another sheet. In the past, I have adjusted the vlookup formulas for each position, which is prone to errors.
If it can be done, you guys will know how to do it.
Thanks!
<tbody>
</tbody>
I need to be able to vlookup the first step rate for the position into another sheet. In the past, I have adjusted the vlookup formulas for each position, which is prone to errors.
If it can be done, you guys will know how to do it.
Thanks!
Position | First Step Rate | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Receptionist | 21.50 | 21.50 | 23.50 | 24.50 | 25.00 | 27.00 | 29.00 | 30.00 | 35.00 | 40.00 |
Technician | 24.50 | 24.50 | 25.00 | 27.00 | 29.00 | 30.00 | 35.00 | 40.00 | ||
Office Manager | 29.00 | 29.00 | 30.00 | 35.00 | 40.00 |
<tbody>
</tbody>