I have a spreadsheet with 2 sheets (Sheet 1 and Sheet 2).

On Sheet 1 Column A (heading is titled Name) and has a list of names in Column A2:A25. Column B (heading is titled Date of Birth) and I need to perform a lookup for the Date of Birth from Sheet 2 based on the Name in Column A on Sheet 1.

Sheet 2 Column A has the following vertical headings (Name, Address, Date of Birth, and Phone Number)

Can anyone help me I have tried Vlookup and index/metch and can not seem to make this work.

Thanks in advance