Thanks in advance for your help.

What I want to do is have a list of completed projects that have date,
project number and description. In my mind this would be a separate
sheet. On a summary sheet, list the completed projects for that day.
It would look like the following:

Completed Project Sheet:

Date Proj. Numb. Description
1/6/2004 123 Proj 1
1/6/2004 125 Proj 2
1/7/2004 130 Proj 4
1/7/2004 132 Proj 5
1/7/2004 135 Proj 6

Summary Sheet
Report Date: 1/7/2004

Proj. Numb. Description
130 Proj 4
131 Proj 5
132 Proj 6

How can I do this? I have tried vlookup and could not make it work.
Thanks again for your help.

John