Look up cell in a vlook up then retrieve cell next to it

[jesusespinoza1]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]JOB
[/TD]
[TD]Operator 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Current rate
[/TD]
[TD]$10.00
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Next Rate
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD]Max
[/TD]
[TD]Rate 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Operator 1
[/TD]
[TD]12.00
[/TD]
[TD]9.00
[/TD]
[TD]9.75
[/TD]
[TD]10.50
[/TD]
[TD]12.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Operator 2
[/TD]
[TD]15.00
[/TD]
[TD]10.00
[/TD]
[TD]12.00
[/TD]
[TD]14.00
[/TD]
[TD]15.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Operator 3
[/TD]
[TD]13.00
[/TD]
[TD]8.50
[/TD]
[TD]10.25
[/TD]
[TD]12.00
[/TD]
[TD]13.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have a compensation spreadsheet that has current wages and the salary structure for the upcoming year. I need to create a formula that will look up the job title and give me the next rate of pay based on the current pay. Lets say EE #1 is a Operator 1 making $10.00 per hour now. I want the formula to look up the pay range for Operator #1 and locate the next pay rate above $10.00. If the current rate is above the max rate then return the max rate

 

[Joe4]

Re: Return cell next to a particular cell (IF, Match, Index)

I have merged your two threads together.

In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).