Excel Formula

Closed
NeedHelp12 - May 25, 2011 at 07:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 25, 2011 at 08:41 AM
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.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 25, 2011 at 08:41 AM
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 ?
0