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