Or is this what you're looking for...
=IF(ISNUMBER(A1)*ISNUMBER(B1),IF((LOOKUP(2,1/A1:A10,A1:A10))*(INDEX(B:B,LOOKUP(2,1/A1:A10,ROW(A1:A10)))=""),LOOKUP(9.99999999999999E+ 307,C:C),0),"")
or, maybe this one...
=IF(ISNUMBER(A1)*ISNUMBER(B1),IF((LOOKUP(2,1/A1:A10,A1:A10))*(INDEX(B:B,LOOKUP(2,1/A1:A10,ROW(A1:A10)))=""),INDEX(C:C,LOOKUP(2,1/A1:A10,ROW(A1:A10))),0),"")
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=278034