Hi Niek,
Thank you, I'm trying this, but what's H1 and G1 in your formula?  Where
does it reference the other spreadsheet I'm trying to get data from?  Say
this is the sheet that contains data:
    01/01/2007 02/01/2007 02/14/2007 02/20/2007
Blue Shirts      1000    1200    1100    1300
Blue Pants     50    75    60    65
Red Shirts      500    700    400    300
Red Pants      20    25    15    10

And I want to fill in this spreadsheet in the appropriate places based on
the description and date:

    01/01/2007 01/15/2007 02/01/2007 02/15/2007
Red Pants               
Blue Pants               
Red Shirts               
Blue Shirts               

Thank you!  -Sissy