Adding data from another sheet

D

Dus@n

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?
 
S

SteveG

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
 
T

Tom Ogilvy

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
 
Top