I have worksheet "OT Report" that looks like this:

EMPLOYEE # SUPERVISOR F NAME L NAME SCH WORKED
41531441 Open Deb Albr 36.00
9725217 Patty Glor Bat 40.00

120615975 Patty Lin Bea 40.00
105815219 Open Eliza Bris 24.00
12276142 Open Br Bro 40.00
37284952 Pat Lake Bro 15.00
143421680 Kathy Sar Bro 40.00

I have another worsheet "Download" that looks like this:

41531441 Albr, Deb R. FIXED CLASS: DA002
HRS: 51.5 WORKED 51.5 NON-WORKED 23.25 PAID
BY PAY CODE PRODUCTIVE 51.5 WEEKEND DAY
9725217 Bat, Glor G. FIXED CLASS: DA002
HRS: 73.75 WORKED 56.75 NON-WORKED 21 PAID
BY PAY CODE PRODUCTIVE 56.75 WEEKEND DAY
120615975 Bea, Lin M. FIXED CLASS: DA002
HRS: 57.5 WORKED 41.5 NON-WORKED 16 PAID

I need a code that looks for a match for employee# from OT Report on
the DownLoad and once it finds the match then finds the word Productive
from the a range associated with the cell location of the match, then
get the value of the cell next to the word productive and put it in the
cell under worked .


--
Teerings3
------------------------------------------------------------------------
Teerings3's Profile: http://www.excelforum.com/member.php...o&userid=29560
View this thread: http://www.excelforum.com/showthread...hreadid=492617