Return Text if True based on multiple criteria

I am using Excel 2007/2010.

I would like to know if there is a formula that would return text values if TRUE based on given criteria.

On sheet 1, I have a tracker that tracks several bits of data.

On sheet 2, I would like to analyze the data contained on sheet 1 based on certain criteria.

I have attached a simple sample excel file of what I am looking for.

Sheet 1 has 3 columns
A: Date
B: Region
C: Name

Sheet 2 has 3 fields of a form
C1: Region (entered manually)
C2: Date (entered manually)
C4: Name (return name if date = C2 and region = c1)

Thanks in advance for your help!