matching names and date of birth on two sheets

[Alison44]

On Sheet1 I have two columns of data. Column A name (100 names), Column B date of birth
On Sheet2 I have one column. Column A name (50 names). These names are also in Column A Sheet1.

I want to find out what the Date of Birth (Sheet1, Column 2) is for all of the names on Sheet2, Column A.

This is probably very easy but I am clueless. Thanks

 

[Rick Rothstein]

Give this formula a try...

=VLOOKUP(A2,Sheet1!A:B,2)

Note: You will have to use Cell Formatting to apply a date format for the date display you want to show.

 

[Alison44]

I am REALLY a beginner. Where do I put that formula? Do I combine the data from the 2 sheets?

 

[Rick Rothstein]

I am REALLY a beginner. Where do I put that formula? Do I combine the data from the 2 sheets?

In cell B2 on Sheet2, then copy it down as (if) needed.

 

[dutch_tejada]

I am REALLY a beginner. Where do I put that formula? Do I combine the data from the 2 sheets?

[TABLE="width: 376"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]Sheet 1[/TD]
[/TR]
[TR]
[TD]Names[/TD]
[TD]Date of Birth[/TD]
[/TR]
[TR]
[TD]Dutch Tejada[/TD]
[TD]8/27/1988[/TD]
[/TR]
[TR]
[TD]Jay Tihoc[/TD]
[TD]12/17/1997[/TD]
[/TR]
[TR]
[TD]Juan Dela Cruz[/TD]
[TD]1/3/1994[/TD]
[/TR]
[TR]
[TD]Era Bacomo[/TD]
[TD]5/23/1983[/TD]
[/TR]
[TR]
[TD]Noemie Ohoylan[/TD]
[TD]6/14/1996[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Sheet 2[/TD]
[/TR]
[TR]
[TD]Names[/TD]
[TD]Date of Birth[/TD]
[/TR]
[TR]
[TD]Dutch Tejada[/TD]
[TD]=VLOOKUP(A2,Sheet1!A:B,2,0)[/TD]
[/TR]
[TR]
[TD]Jay Tihoc[/TD]
[TD]12/17/1997[/TD]
[/TR]
[TR]
[TD]Noemie Ohoylan[/TD]
[TD]6/14/1996[/TD]
[/TR]
</tbody>[/TABLE]

 

[Alison44]

Thank you for your reply. I am still having some trouble making this work. Why did you add a zero to the end of your formula? The previous person who responded didn't have a zero.

 

[dutch_tejada]

When you use VLOOKUP to return a value from a data table, the function does not differentiate between blanks and zero values in what it returns. If the source value is zero, then VLOOKUP returns 0. Likewise, if the source is blank, then VLOOKUP still returns the value 0. For some purposes, this may not do—you need to know whether the cell being looked up is blank or if it really contains a 0.

Returning Blanks with VLOOKUP (Microsoft Excel)

 

[Alison44]

Ok. Looking at the attached link I used:
=IF(VLOOKUP(A2,Sheet1!A:B,2)="","",VLOOKUP(A2,A:B,2)) and got a zero for a name that was not on Sheet1, which is correct. Should I copy the same formula down Column B on Sheet 2 to retrieve that date in Column 2 on Sheet 1?

 

[Alison44]

[TABLE="width: 500"]
<TBODY>[TR]
[TD]Maybe these example tables will help?
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sheet1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[TD]DOB
[/TD]
[/TR]
[TR]
[TD]Doe,Jane
[/TD]
[TD]4/6/69
[/TD]
[/TR]
[TR]
[TD]James,John
[/TD]
[TD]11/2/10
[/TD]
[/TR]
[TR]
[TD]Smith,Robert
[/TD]
[TD]12/1/78
[/TD]
[/TR]
[TR]
[TD]Swift,Mark
[/TD]
[TD]11/4/58
[/TD]
[/TR]
[TR]
[TD]Boge,Joan
[/TD]
[TD]2/7/57
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<TBODY>[TR]
[TD]Sheet2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[TD]DOB
[/TD]
[/TR]
[TR]
[TD]Doe,Jane
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Boge,Joan
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Swift,Mark
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD]Both Sheets have 2 columns. I am trying to copy the correct DOB's from Sheet1 to Sheet 2
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[dutch_tejada]

Yes sure you can... I think it will be simplier if you use this, =IF(A2="","",VLOOKUP(A2,Sheet1!A:B,2,0)). This means, if the data could not be found in sheet1, then the column B in sheet2 will be blank