Try this in B14.

=IF(SUMPRODUCT(($A$1:$A$7=$A14)*($C$1:$C$7=MAX($C$ 1:$C$7))*$B$1:$B$7)=0,"N/A",SUMPRODUCT(($A$1:$A$7=$A14)*($C$1:$C$7=MAX($C$1 :$C$7))*$B$1:$B$7))

Where A14:A17 is your lookup values (ABC, DEF etc...). This will
return N/A if there is no data for the most recent date for the lookup
value. In your example it was GHI. This will work from one sheet to
another.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522852