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

the suggestion you received is as good a guess as any:

=IF(INDIRECT("Sheet2!G"&MATCH(A1,Sheet2!A:A,0)+2)= "Productive",INDIRECT("She
et2!H"&MATCH(A1,Sheet2!A:A,0)+2),"")

--
Regards,
Tom Ogilvy


"Teerings3" wrote
in message ...




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

I have a worksheet named (OT Report) it looks as follows:

A = Emplyee # B= Supervisor C= FirstName D= Last Name E= Scheduled
Hours F= Worked Hour

example data

A B C D F
41531441 Open Deb Albr 36
9725217 Patty Glor Bat 40
120615975 Patty Lin Bea 40
105815219 Open Eliza Bris 24
12276142 Open Br Bro 40
37284952 Pat Lake Bro 15
143421680 Kathy Sar Bro 40

The other worksheet is called (Download), it does not have header it is
just a download of converted data it looks like this:

41531441 Albr, Deb R. FIXED CLASS: DA002
HRS: 51.5 WORKED 60 NON-WORKED 23.25 PAID
BY PAY CODE PRODUCTIVE 60 WEEKEND DAY
120615975 Bea, Lin M. FIXED CLASS: DA002
HRS: 57.5 WORKED 50 NON-WORKED 16 PAID
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


Now here is what I need:

Employee# from (OT Report ) to find a match on (Download) and once
found to look the range 2 rows down and 7 columns over and find the
word "Productive" once found look 1 cell next to and return that value
to column F of (OT Report). The reason I can not just count over once
it matched employee # id is the protuctive worked might not always be
in the same cell with every download but will be in at least one cell
in the 2 rows down and 7 columns over.

Do yoy know anything that will work Formula or code?
Thanks


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

See answer to latest posting.

--
Regards,
Tom Ogilvy


"Teerings3" wrote in
message ...

I have a worksheet named (OT Report) it looks as follows:

A = Emplyee # B= Supervisor C= FirstName D= Last Name E= Scheduled
Hours F= Worked Hour

example data

A B C D F
41531441 Open Deb Albr 36
9725217 Patty Glor Bat 40
120615975 Patty Lin Bea 40
105815219 Open Eliza Bris 24
12276142 Open Br Bro 40
37284952 Pat Lake Bro 15
143421680 Kathy Sar Bro 40

The other worksheet is called (Download), it does not have header it is
just a download of converted data it looks like this:

41531441 Albr, Deb R. FIXED CLASS: DA002
HRS: 51.5 WORKED 60 NON-WORKED 23.25 PAID
BY PAY CODE PRODUCTIVE 60 WEEKEND DAY
120615975 Bea, Lin M. FIXED CLASS: DA002
HRS: 57.5 WORKED 50 NON-WORKED 16 PAID
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


Now here is what I need:

Employee# from (OT Report ) to find a match on (Download) and once
found to look the range 2 rows down and 7 columns over and find the
word "Productive" once found look 1 cell next to and return that value
to column F of (OT Report). The reason I can not just count over once
it matched employee # id is the protuctive worked might not always be
in the same cell with every download but will be in at least one cell
in the 2 rows down and 7 columns over.

Do yoy know anything that will work Formula or code?
Thanks


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