Hi, Use this:

=INDEX(IF($E2=$A$15:$A$25,$C$15:$C$25),MATCH(F$1,I F($E2=$A$15:$A$25,$B$15:$B$25,0)))

Whe
E2 is the Project in the table
A15:A25 is the list of projects in your data.
C15:C25 is the list of 'Amounts'
F1 is the dates in the table
and B15:B25 is the list of dates

Enter this with ctrl+shift+enter (instead of just pressing enter), and
then drag the cell across the table.

If a date is not available for the project it returns FALSE

Hope this helps!

Alastair


--
spog00
------------------------------------------------------------------------
spog00's Profile: http://www.excelforum.com/member.php...o&userid=20197
View this thread: http://www.excelforum.com/showthread...hreadid=374140