I have two sheets:
- sheet 1 contains: name; first name; number;....
- sheet 2 contains: name; first name; number; birth date....

All persons that are in sheet 1 are also in sheet 2 (but not vice versa).
Name, first name and number all same in both sheets.

I would like to add to sheet 1 birth date of each person fron sheet 2. How?

Assuming you want the name, first name and number to all match then,

=SUMPRODUCT((Sheet2!$A$2:$A$6=Sheet1!A2)*(Sheet2!$ B$2:$B$6=Sheet1!B2)*(Sheet2!$C$2:$C$6=Sheet1!C2)*( Sheet2!$D$2:$D$6))

Where Sheet2!A2:D6 is your table.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522606

assuming Number is unique

In the next available column in sheet 1 (assume F2)

=vlookup(c2,'Sheet 2'!$C$2:$D$1000,2,False)

then drag fill down the column

--
Regards,
Tom Ogilvy


"Dus@n" wrote:

I have two sheets:
- sheet 1 contains: name; first name; number;....
- sheet 2 contains: name; first name; number; birth date....

All persons that are in sheet 1 are also in sheet 2 (but not vice versa).
Name, first name and number all same in both sheets.

I would like to add to sheet 1 birth date of each person fron sheet 2. How?