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

 

[JoeMo]

Re: Look up cell in a vlook up then retrieve cell next to it-- Please help

Excel Workbook
	A	B	C	D	E	F
1	JOB	Operator 1
2	Current rate	$10.00
3	Next Rate	10.5
4		Max	Rate 1
5	Operator 1	12	9	9.75	10.5	12
6	Operator 2	15	10	12	14	15
7	Operator 3	13	8.5	10.25	12	13
Sheet9

 

[jesusespinoza1]

Re: Look up cell in a vlook up then retrieve cell next to it-- Please help

The formula kind of works.
Issues:

1. The formula works as written but I have to makesure the last MATCH references the correct row: for example as its writtenMATCH(B2, C5:F5,1)+1)). It works in the original example because Operator 1 wasthe first pay range. But in my actualspreadsheet there are 32 jobs and the job I am looking for is not always in thefirst row.
   
   
   
   I basically need to enter a formula into Column E that willlook at the Job Title and Current Pay Rate and look that up on the wagestructure (2nd pasted picture below) and tell me what is the next Rate that person is due. Once I enterthat formula I can then drag the formula through column E to all 200+ employees

A

<tbody>
[TD="width: 82, bgcolor: transparent"] B [/TD]
[TD="width: 82, bgcolor: transparent"] C [/TD]
[TD="width: 82, bgcolor: transparent"] D [/TD]
[TD="width: 82, bgcolor: transparent"] E [/TD]
[TD="width: 82, bgcolor: transparent"] F [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 1 [/TD]
[TD="width: 82"] EE Name [/TD]
[TD="width: 82"] Job Title [/TD]
[TD="width: 82"] Current Rate [/TD]
[TD="width: 82"] Next Rate [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 2 [/TD]
[TD="width: 82, bgcolor: transparent"] John [/TD]
[TD="width: 82, bgcolor: transparent"] Slitter Operator [/TD]
[TD="width: 82, bgcolor: transparent"] $15.50 [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 3 [/TD]
[TD="width: 82, bgcolor: transparent"] Michael [/TD]
[TD="width: 82, bgcolor: transparent"] Slitter Operator [/TD]
[TD="width: 82, bgcolor: transparent"] $16.50 [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 4 [/TD]
[TD="width: 82, bgcolor: transparent"] Patty [/TD]
[TD="width: 82, bgcolor: transparent"] Mechanic [/TD]
[TD="width: 82, bgcolor: transparent"] $18.00 [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 5 [/TD]
[TD="width: 82, bgcolor: transparent"] Mary [/TD]
[TD="width: 82, bgcolor: transparent"] Janitor [/TD]
[TD="width: 82, bgcolor: transparent"] $11.50 [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 6 [/TD]
[TD="width: 82, bgcolor: transparent"] Sean [/TD]
[TD="width: 82, bgcolor: transparent"] Mechanic [/TD]
[TD="width: 82, bgcolor: transparent"] $19.00 [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 7 [/TD]
[TD="width: 82, bgcolor: transparent"] Steven [/TD]
[TD="width: 82, bgcolor: transparent"] Janitor [/TD]
[TD="width: 82, bgcolor: transparent"] $10.00 [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 8 [/TD]
[TD="width: 82, bgcolor: transparent"] Joe [/TD]
[TD="width: 82, bgcolor: transparent"] Planner [/TD]
[TD="width: 82, bgcolor: transparent"] $19.75 [/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

</tbody>

 

[Aladin Akyurek]

Re: Look up cell in a vlook up then retrieve cell next to it-- Please help

In B3 control+shift+enter, not just enter:

=IF(INDEX($B$5:$B$7,MATCH(B1,$A$5:$A$7,0))=B2,B2,MIN(IF($A$5:$A$7=B1,IF($C$5:$F$7>B2,$C$5:$F$7))))

 

[jesusespinoza1]

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

A

<tbody>
[TD="width: 82, bgcolor: transparent"] B
[/TD]
[TD="width: 82, bgcolor: transparent"] C
[/TD]
[TD="width: 82, bgcolor: transparent"] D
[/TD]
[TD="width: 82, bgcolor: transparent"] E
[/TD]
[TD="width: 82, bgcolor: transparent"] F
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 1
[/TD]
[TD="width: 82"] EE Name
[/TD]
[TD="width: 82"] Job Title
[/TD]
[TD="width: 82"] Current Rate
[/TD]
[TD="width: 82"] Next Rate
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 2
[/TD]
[TD="width: 82, bgcolor: transparent"] John
[/TD]
[TD="width: 82, bgcolor: transparent"] Slitter Operator
[/TD]
[TD="width: 82, bgcolor: transparent"] $15.50
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 3
[/TD]
[TD="width: 82, bgcolor: transparent"] Michael
[/TD]
[TD="width: 82, bgcolor: transparent"] Slitter Operator
[/TD]
[TD="width: 82, bgcolor: transparent"] $16.50
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 4
[/TD]
[TD="width: 82, bgcolor: transparent"] Patty
[/TD]
[TD="width: 82, bgcolor: transparent"] Mechanic
[/TD]
[TD="width: 82, bgcolor: transparent"] $18.00
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 5
[/TD]
[TD="width: 82, bgcolor: transparent"] Mary
[/TD]
[TD="width: 82, bgcolor: transparent"] Janitor
[/TD]
[TD="width: 82, bgcolor: transparent"] $11.50
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 6
[/TD]
[TD="width: 82, bgcolor: transparent"] Sean
[/TD]
[TD="width: 82, bgcolor: transparent"] Mechanic
[/TD]
[TD="width: 82, bgcolor: transparent"] $19.00
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 7
[/TD]
[TD="width: 82, bgcolor: transparent"] Steven
[/TD]
[TD="width: 82, bgcolor: transparent"] Janitor
[/TD]
[TD="width: 82, bgcolor: transparent"] $10.00
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

[TD="width: 82, bgcolor: transparent"] 8
[/TD]
[TD="width: 82, bgcolor: transparent"] Joe
[/TD]
[TD="width: 82, bgcolor: transparent"] Planner
[/TD]
[TD="width: 82, bgcolor: transparent"] $19.75
[/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]

</tbody>

I basically need to enter a formula into Column E that willlook at the Job Title and Current Pay Rate and look that up on the wagestructure and tell me what is the next Rate that person is due. Once I enterthat formula I can then drag the formula through column E to all 200+ employees
[TABLE="width: 10"]
<tbody>[TR]
[TD="width: 132, colspan: 2"][/TD]
[TD="width: 132"][/TD]
[TD="width: 53"][/TD]
[TD="width: 61"][/TD]
[TD="width: 55"][/TD]
[TD="width: 65"][/TD]
[TD="width: 66"][/TD]
[TD="width: 121, colspan: 2"][/TD]
[TD="width: 65"][/TD]
[TD="width: 72"][/TD]
[TD="width: 66"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 132, colspan: 2"]1 A
[/TD]
[TD="width: 132"]

B​

[/TD]
[TD="width: 53"]

C​

[/TD]
[TD="width: 61"]

D​

[/TD]
[TD="width: 55"]

E​

[/TD]
[TD="width: 65"]

F​

[/TD]
[TD="width: 66"]

E​

[/TD]
[TD="width: 121, colspan: 2"]

F g​

[/TD]
[TD="width: 65"]

I​

[/TD]
[TD="width: 72"]

J​

[/TD]
[TD="width: 66"]

K​

[/TD]
[TD="width: 72"]

L​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

2​

[/TD]
[TD="width: 228, colspan: 2"]

Job Title​

[/TD]
[TD="width: 53"]

Empty 1​

[/TD]
[TD="width: 61"]

Range Max​

[/TD]
[TD="width: 55"]

0​

[/TD]
[TD="width: 65"]

0.5​

[/TD]
[TD="width: 66"]

1​

[/TD]
[TD="width: 66"]

1.5​

[/TD]
[TD="width: 55"]

2​

[/TD]
[TD="width: 65"]

3​

[/TD]
[TD="width: 72"]

4​

[/TD]
[TD="width: 66"]

5​

[/TD]
[TD="width: 72"]

6​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

3​

[/TD]
[TD="width: 228, bgcolor: transparent, colspan: 2"]Utility
[/TD]
[TD="width: 53, bgcolor: transparent"][/TD]
[TD="width: 61"]

$22.90 ​

[/TD]
[TD="width: 55"]

$18.47 ​

[/TD]
[TD="width: 65"]

$19.36 ​

[/TD]
[TD="width: 66"]

$20.24 ​

[/TD]
[TD="width: 66"]

$21.13 ​

[/TD]
[TD="width: 55"]

$22.02 ​

[/TD]
[TD="width: 65"]

$22.90 ​

[/TD]
[TD="width: 72"]

$22.90 ​

[/TD]
[TD="width: 66"]

$22.90 ​

[/TD]
[TD="width: 72"]

$22.90 ​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

4​

[/TD]
[TD="width: 228, bgcolor: transparent, colspan: 2"]Planner
[/TD]
[TD="width: 53, bgcolor: transparent"][/TD]
[TD="width: 61"]

$22.85 ​

[/TD]
[TD="width: 55"]

$18.43 ​

[/TD]
[TD="width: 65"]

$19.31 ​

[/TD]
[TD="width: 66"]

$20.19 ​

[/TD]
[TD="width: 66"]

$21.08 ​

[/TD]
[TD="width: 55"]

$21.96 ​

[/TD]
[TD="width: 65"]

$22.85 ​

[/TD]
[TD="width: 72"]

$22.85 ​

[/TD]
[TD="width: 66"]

$22.85 ​

[/TD]
[TD="width: 72"]

$22.85 ​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

5​

[/TD]
[TD="width: 228, bgcolor: transparent, colspan: 2"]Plate Maker
[/TD]
[TD="width: 53, bgcolor: transparent"][/TD]
[TD="width: 61"]

$23.12 ​

[/TD]
[TD="width: 55"]

$18.64 ​

[/TD]
[TD="width: 65"]

$19.54 ​

[/TD]
[TD="width: 66"]

$20.43 ​

[/TD]
[TD="width: 66"]

$21.33 ​

[/TD]
[TD="width: 55"]

$22.22 ​

[/TD]
[TD="width: 65"]

$23.12 ​

[/TD]
[TD="width: 72"]

$23.12 ​

[/TD]
[TD="width: 66"]

$23.12 ​

[/TD]
[TD="width: 72"]

$23.12 ​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

6​

[/TD]
[TD="width: 228, bgcolor: transparent, colspan: 2"]Slitter Operator
[/TD]
[TD="width: 53, bgcolor: transparent"][/TD]
[TD="width: 61"]

$17.00 ​

[/TD]
[TD="width: 55"]

$12.00 ​

[/TD]
[TD="width: 65"]

$13.00 ​

[/TD]
[TD="width: 66"]

$14.00 ​

[/TD]
[TD="width: 66"]

$15.00 ​

[/TD]
[TD="width: 55"]

$16.50 ​

[/TD]
[TD="width: 65"]

$17.00 ​

[/TD]
[TD="width: 72"]

$17.00 ​

[/TD]
[TD="width: 66"]

$17.00 ​

[/TD]
[TD="width: 72"]

$17.00 ​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

7​

[/TD]
[TD="width: 228, bgcolor: transparent, colspan: 2"]Mechanic
[/TD]
[TD="width: 53, bgcolor: transparent"][/TD]
[TD="width: 61"]

$22.73 ​

[/TD]
[TD="width: 55"]

$18.33 ​

[/TD]
[TD="width: 65"]

$19.21 ​

[/TD]
[TD="width: 66"]

$20.09 ​

[/TD]
[TD="width: 66"]

$20.97 ​

[/TD]
[TD="width: 55"]

$21.85 ​

[/TD]
[TD="width: 65"]

$22.73 ​

[/TD]
[TD="width: 72"]

$22.73 ​

[/TD]
[TD="width: 66"]

$22.73 ​

[/TD]
[TD="width: 72"]

$22.73 ​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

8​

[/TD]
[TD="width: 228, bgcolor: transparent, colspan: 2"]Machine Operator
[/TD]
[TD="width: 53, bgcolor: transparent"][/TD]
[TD="width: 61"]

$22.28 ​

[/TD]
[TD="width: 55"]

$17.97 ​

[/TD]
[TD="width: 65"]

$18.83 ​

[/TD]
[TD="width: 66"]

$19.69 ​

[/TD]
[TD="width: 66"]

$20.55 ​

[/TD]
[TD="width: 55"]

$21.42 ​

[/TD]
[TD="width: 65"]

$22.28 ​

[/TD]
[TD="width: 72"]

$22.28 ​

[/TD]
[TD="width: 66"]

$22.28 ​

[/TD]
[TD="width: 72"]

$22.28 ​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

9​

[/TD]
[TD="width: 228, bgcolor: transparent, colspan: 2"]Janitor
[/TD]
[TD="width: 53, bgcolor: transparent"][/TD]
[TD="width: 61"]

$15.00 ​

[/TD]
[TD="width: 55"]

$11.00 ​

[/TD]
[TD="width: 65"]

$12.00 ​

[/TD]
[TD="width: 66"]

$13.00 ​

[/TD]
[TD="width: 66"]

$13.50 ​

[/TD]
[TD="width: 55"]

$14.50 ​

[/TD]
[TD="width: 65"]

$15.00 ​

[/TD]
[TD="width: 72"]

$15.00 ​

[/TD]
[TD="width: 66"]

$15.00 ​

[/TD]
[TD="width: 72"]

$15.00 ​

[/TD]
[/TR]
[TR]
[TD="width: 36, bgcolor: transparent"]

10​

[/TD]
[TD="width: 228, bgcolor: transparent, colspan: 2"][/TD]
[TD="width: 53, bgcolor: transparent"][/TD]
[TD="width: 61"][/TD]
[TD="width: 55"][/TD]
[TD="width: 65"][/TD]
[TD="width: 66"][/TD]
[TD="width: 66"][/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 65, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

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

Try:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
Janitor

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]EE Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Job Title[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Current Rate[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "] Next Rate [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]Job Title[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]Empty 1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]Range Max[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]0[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]0.5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]1.5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: center"]6[/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]John[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Slitter Operator[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$15.50 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"] $16.50 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Utility[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.90 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$0.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$18.47 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19.36 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$20.24 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$21.13 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.02 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.90 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.90 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.90 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.90 [/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Michael[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Slitter Operator[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$16.50 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"] $17.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Planner[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.85 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$0.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$18.43 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19.31 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$20.19 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$21.08 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$21.96 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.85 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.85 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.85 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.85 [/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Patty[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Mechanic[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$18.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"] $18.33 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Plate Maker[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$23.12 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$0.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$18.64 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19.54 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$20.43 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$21.33 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.22 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$23.12 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$23.12 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$23.12 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$23.12 [/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Mary[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Janitor[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$11.50 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"] $12.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Slitter Operator[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$0.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$12.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$13.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$14.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$15.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$16.50 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17.00 [/TD]

[TD="align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Sean[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Mechanic[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"] $19.21 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Mechanic[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.73 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$0.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$18.33 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19.21 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$20.09 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$20.97 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$21.85 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.73 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.73 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.73 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.73 [/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Steven[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Janitor[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$10.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"] $11.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Machine Operator[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.28 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$0.00 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17.97 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$18.83 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19.69 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$20.55 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$21.42 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.28 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.28 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.28 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$22.28 [/TD]

[TD="align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Joe[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Planner[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19.75 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"] $20.19 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$15.00 [/TD]
[TD="align: right"]$0.00 [/TD]
[TD="align: right"]$11.00 [/TD]
[TD="align: right"]$12.00 [/TD]
[TD="align: right"]$13.00 [/TD]
[TD="align: right"]$13.50 [/TD]
[TD="align: right"]$14.50 [/TD]
[TD="align: right"]$15.00 [/TD]
[TD="align: right"]$15.00 [/TD]
[TD="align: right"]$15.00 [/TD]
[TD="align: right"]$15.00 [/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]=LOOKUP(D2,INDEX($M$2:$U$8,MATCH(C2,$I$2:$I$8,0),0),INDEX($N$2:$V$8,MATCH(C2,$I$2:$I$8,0),0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



I added a column with zeros in M. This is to handle the cases where the current pay is less than the minimum, like rows 4 and 7. You can hide the column if you want.

 

[jesusespinoza1]

Re: Look up cell in a vlook up then retrieve cell next to it-- Please help

Thanks Aladin. The formula works.
However when I drag the formula down it doesn't work anymore. I have 200+ Employees and I need to enter that formula in a spreadsheet and drag it down.

 

[Aladin Akyurek]

Re: Look up cell in a vlook up then retrieve cell next to it-- Please help

Thanks Aladin. The formula works.
However when I drag the formula down it doesn't work anymore. I have 200+ Employees and I need to enter that formula in a spreadsheet and drag it down.

It's your layout as you specified in post #1 which does not allow "copying down", but it does to the right...

Book1
	A	B	C	D	E	F	G
1	JOB	Operator 1	Operator 2
2	Current rate	$10.00	$12.00
3	Next Rate	10.5	14
4		Max	Rate 1	Rate 2	Rate 3	Rate 4
5	Operator 1	12	9	9.75	10.5	12
6	Operator 2	15	10	12	14	15
7	Operator 3	13	8.5	10.25	12	13
Sheet1

In B3 control+shift+enter, not just enter, and copy across:

=IF(INDEX($B$5:$B$7,MATCH(B1,$A$5:$A$7,0))=B2,B2,MIN(IF($A$5:$A$7=B1,IF($C$5:$F$7>B2,$C$5:$F$7))))

 

[jesusespinoza1]

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

Eric thanks so much. It works great.

Just one thing maybe you can help with. When the employees current rate is above the MAX Rate can it return the current rate. Is it possible to tweak formula to add this? This would make it work perfectly.

 

[Eric W]

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

See if this works for you:

=IF(D2>=INDEX($V$2:$V$8,MATCH(C2,$I$2:$I$8,0)),D2,LOOKUP(D2,INDEX($M$2:$U$8,MATCH(C2,$I$2:$I$8,0),0),INDEX($N$2:$V$8,MATCH(C2,$I$2:$I$8,0),0)))