For the first date:

Summary sheet A1 = 2007-1

=VLOOKUP(A1,Sheet1!A2:D10,2,0)

For the second date (note: this formula will return the date corresponding
to the *LAST INSTANCE* of 2007-1. If there are only 2 instances it will
return the second instance. If there are 10 instances it will return the
10th instance)

=LOOKUP(2,1/(Sheet1!A2:A10=A1),Sheet1!B2:B10)

Both formula cells need to be formatted as DATE.

Biff

"Slider" wrote in message
...
I have the following raw data setup:

Invoice# Date Description Amount
2007-1 4/1/07 Signage 250.00
2007-1 4/1/07 Mugs 115.00
2007-2 4/2/07 Signage 275.00

In a summary sheet:

I would like to pull the first "Date" for "Invoice#" 2007-1 on line 1.
If Invoice# 2007-1 has a second record, I would like to then pull the
second
"Date" for "Invoice#" 2007-1 on line 2.

Thank you in advance for your help