Adding data from another sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dus@n - 15 Mar 2006 13:56 GMT

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?

Reply to this Message

SteveG - 15 Mar 2006 15:23 GMT

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

Signature

SteveG

Reply to this Message

Tom Ogilvy - 15 Mar 2006 15:31 GMT

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

Signature

Regards,
Tom Ogilvy

> I have two sheets:
> - sheet 1 contains: name; first name; number;....
[quoted text clipped - 4 lines]
>
> I would like to add to sheet 1 birth date of each person fron sheet 2. How?

Reply to this Message