Excel Formula

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
So lets say row 3 does not match. In that case what should be on row 3 of the new sheet. A blank row or it should put the value of the next match there ?