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