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?