=INDIRECT(ADDRESS(MATCH(A:A,Sheet2!A:A,0)+1,4,4,1, "Sheet2"))

I need help changing this a little, once it finds a match it looks down
2 rows and over 7 rows for the cell containg the word "Productive" and
then go 1 cell over to the right and that is the value I need.

thanks for the help
:(


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