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

J

jesusespinoza1

New Member
Joined
Jun 24, 2015
Messages
12
[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
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
Re: Look up cell in a vlook up then retrieve cell next to it-- Please help

Excel Workbook
ABCDEF
1JOBOperator 1
2Current rate$10.00
3Next Rate10.5
4MaxRate 1
5Operator 11299.7510.512
6Operator 21510121415
7Operator 3138.510.251213
Sheet9
 
Upvote 0
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>
 
Last edited by a moderator:
Upvote 0
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))))
 
Upvote 0
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]
 
Upvote 0
Re: Return cell next to a particular cell (IF, Match, Index)

Try:

ABCDEFGHIJKLMNOPQRSTUV
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.
 
Upvote 0
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.
 
Upvote 0
Re: Look up cell in a vlook up then retrieve cell next to it-- Please help

jesusespinoza1 said:
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.
Click to expand...

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


Book1
ABCDEFG
1JOBOperator 1Operator 2
2Current rate$10.00$12.00
3Next Rate10.514
4MaxRate 1Rate 2Rate 3Rate 4
5Operator 11299.7510.512
6Operator 21510121415
7Operator 3138.510.251213
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))))
 
Upvote 0
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.
 
Upvote 0
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)))
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Locked
  • Question Question
Check and copy most current non blank cell over the course of a month
Replies
4
Views
587
Fluff
Fluff
T
  • Question Question
copy the first two columns and the last column from sheet to next sheet based on current month
Replies
2
Views
329
tubrak
T
C
  • Solved
Create Function that Calculates a Value Relative to Original Price and Also Constructs a Price Ladder
2
Replies
10
Views
1K
NdNoviceHlp
NdNoviceHlp
Y
  • Question Question
Look Up Between Two Numbers
Replies
2
Views
558
yhasan527
Y
S
  • Question Question
Vlookup, match, interpolation help reqd.
2
Replies
10
Views
3K
Sandeep Warrier
Sandeep Warrier

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top