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

[jesusespinoza1]

	A	B	C	D	E	F	G
1	JOB	Operator 1
2	Current rate	$10.00
3	Next Rate
4		Max	Rate 1
5	Operator 1	12.00	9.00	9.75	10.50	12.00
6	Operator 2	15.00	10.00	12.00	14.00	15.00
7	Operator 3	13.00	8.50	10.25	12.00	13.00
8
9

<tbody>
</tbody>

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).