Formula for a lookup

[randolphoralph]

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

[DonkeyOte]

Without seeing the data - ie consistency - try:

Sheet1
B2: =VLOOKUP($A2,Sheet2!$A:$C,3,0)
copied down

Where no match is found (on name) #N/A will result - and will need to be investigated.

[randolphoralph]

I tried the formula and it appears to be pulling information from Column C on Sheet 2.

I am unable to upload the file due to admin restrictions on the computer that I am on.

Here is and example of what it looks like. I have bolded the Headings of each sheet.

Sheet 1:

Column A Column B
Name Date of Birth
Mary formula for lookup to return 9/1/1940
Bill formula for lookup to return 10/1/1980
Many other names

Sheet 2:

Column A Column B
Bill
Address 123 Main St
Date of Birth 10/1/1980
Phone Number (555) 555-5555

Mary
Address 567 Main St
Date of Birth 9/1/1940
Phone Number (222) 222-2222

[DonkeyOte]

Sorry my mistake I saw vertical headings and thought Horizontal!

Assuming DOB always appears in the 2nd row beneath the name try:

=INDEX(Sheet2!$B:$B,MATCH($A2,Sheet2!$A:$A,0)+2)

[randolphoralph]

Thanks DonkeyOte you Rock!

I have been going back and forth on trying to get this to work for two days.