Hello
I have a large worksheet with contact details and booking areas (Booking 1,
Booking 2 etc.):

                                             Booking 1                      
   Booking 2
Title Forename  Name      Area      From      To            Area       From  
   To    
Mr         Alex       Smith    Blue       5/1/08   8/7/08       Orange  
4/1/08   2/10/09
Ms         Vicki       Life      Orange   8/1/08  15/7/08       Blue    
10/1/08  20/10/08

In another excel file (or in another worksheet) i would like to see the name
of the person who has the same entry date and area. See example:

Date                 Blue                               Orange              
1/01/08
2/01/08
3/01/08
4/01/08                                                 Mr Alex Smith
5/01/08            Mr Alex Smith
6/01/08
7/01/08
8/01/08                                                  Ms Vicki Life
9/01/08
10/01/08          Ms Vicki Life
etc.

I tried it with DGET (it's not the best solution because i have to create a
massive worksheet) What about SUMPRODUCT?
Thanks for your help.