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

 

[Alison44]

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

Thank you! My "name" column on both sheets were not in the same format (They did not consistently include a middle initial). So I had to split Column A on both sheets into three columns - last, first, initial. So now Sheet1 has three columns last, first and date of birth. Sheet2 has 2 columns last and first. I removed the middle initial column on both sheets.

I still need to do the same thing - pull date of birth from Sheet1 to Sheet2. I will play around with the formula that you provided to see if I can make it work with my changes because my data is in different columns now. Thank you for all of your help with this. I am learning a lot. Sheet1 now looks like this:

[TABLE="width: 500, align: left"]
<TBODY>[TR]
[TD][TABLE="width: 500, align: left"]
<TBODY>[TR]
[TD]ColumnA[/TD]
[TD]ColB[/TD]
[TD]ColC[/TD]
[/TR]
[TR]
[TD]Last[/TD]
[TD]First[/TD]
[TD]Date of Birth[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD]Joe[/TD]
[TD]4/1/69[/TD]
[/TR]
[TR]
[TD]Smithz[/TD]
[TD]Jane[/TD]
[TD]5/1/69[/TD]
[/TR]
[TR]
[TD]Smithy[/TD]
[TD]Joy[/TD]
[TD]6/1/69[/TD]
[/TR]
[TR]
[TD]Smithx[/TD]
[TD]Jorge[/TD]
[TD]7/1/69[/TD]
[/TR]
[TR]
[TD]Smithw[/TD]
[TD]Jim[/TD]
[TD]8/1/69[/TD]
[/TR]
[TR]
[TD]Smithm[/TD]
[TD]Cara[/TD]
[TD]9/1/69[/TD]
[/TR]
[TR]
[TD]Smithn[/TD]
[TD]Jen[/TD]
[TD]10/1/69[/TD]
[/TR]
[TR]
[TD]Smitho[/TD]
[TD]Peter[/TD]
[TD]11/1/69[/TD]
[/TR]
[TR]
[TD]Smithl[/TD]
[TD]John[/TD]
[TD]12/1/69[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]


[TABLE="width: 500, align: left"]
<TBODY>[TR]
[TD]ColumnA[/TD]
[TD]ColB[/TD]
[TD]ColC[/TD]
[/TR]
[TR]
[TD]Last[/TD]
[TD]First[/TD]
[TD]Date of Birth[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD]Joe[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Smithz[/TD]
[TD]Jane[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Smithy[/TD]
[TD]Joy[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Smithp[/TD]
[TD]Larry[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Smithq[/TD]
[TD]Bert[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]