Previous Topic Next Topic

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.

1 response

Answer 1 / 1
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response