Now it gets a bit more complicated. I have to use Start Date and End Date on
sheet1

Sheet 1 - Column A: Start Date, Column B: End Date, Coulmn C:Names:, Column
D: Control Numbers,
Sheet 2 - Column A: Date, Column B: Names, Column C: Code Numbers,
In Column D on sheet 2, I want to see the Control Number for the specific
Name and specific Date if the date on sheet2 either matches the start or
end date or is between the dates.

Thanks