I don't think you're going to to this strictly with formulas. A macro could
do it, or you can do it with filters. Highlight your table, then on the menu
bar Data Filter Autofilter. Use the drop-down in col B to select Custom,
then use the dialog to choose <= 1/21/06. Use the drop-down in col C to
select Custom, then use the dialog to choose =1-21-06. All the rows now
visible should meet your criteria. So select then all, copy and paste to
sheet1.

"Mark B" wrote:

I want to pull in to Sheet 1 a list of names from another sheet based upon a
date range in the second sheet...

In my example, the reason Fred is in ColA on Sheet 1 is because his date
range in Sheet 2 matches this formula... ColB<=01-21-06 AND ColC =01-21-06

Sheet 1 Sheet 2
ColA ColB ColA ColB ColC
1-21-06 1-28-06 Fred 1-19-06 1-24-06
Fred Lucy Ethel 1-19-06 1-24-06
Ethel Ricky Lucy 1-26-06 1-30-06
Ricky 1-26-06 1-30-06