Excel Formula

Hello,

I have 1 Workbook with 2 sheets full of data, both sheets have identical data except for 2 Columns, DOB and Last name. I want a Formula on SHEET 3 which will look FOR DOB of Sheet1 = DOB of Sheet 2 and LAST Name of sheet 1 = Last name of Sheet 2 and the Results to appear on Sheet 3. What I want in Results is to show the whole Row of Sheet 1 if the results match else ignore.


Thanks in advance.