May 25, 2011 at 07:26 AM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
May 25, 2011 at 08:41 AM
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.