Hello,

I have a question about a formula which I am stuck on.

I was given 2 worksheets:

First with employee SSN, name and their dependent's names (aprxmate 700 rows).

example:

A B C D
E
SSN Employee First Name Last Name Dependent Fname DLName
123456789 Peyton Manning Jordan
Manning
111111111 Tom Brady Sarah
Brady
111111111 Tom Brady Joel
Brady


Second worksheet with same things but also have Dependents Birthdate and
address (aprx 3400 rows).

example:

A B D E F
G
SSN Employee First Name DFname DLname DepDOB DepAddress
123456789 Peyton Jordan Manning 1/1/1999 123 A St
111111111 Tom Sarah Brady 2/1/2003 321 B St
111111111 Tom Joel Brady 3/1/2005 321
B St

I would like to put the dependents DOB and address from the 2nd worksheet to
the 1st ws accurately. So far I've ever only used a match formula where you
match 1 unique key (SSN) but have never used a formula where you first match
one thing and if its true than you match another thing and if that's true
then you return a specified array which in this case would be columns F and G
from worksheet 2. Please let me know if this is possible.

As always thank you for looking,

--
Thank You!