Using your sample data. In Sheet3! column A, input your names. For the
birthday in B2 input the following:

=VLOOKUP(A2,Sheet1!$A$1:$C$8,3,FALSE)

Format your cells with a date format.

For the city in C2 input,

=VLOOKUP(A2,Sheet2!$A$1:$B$8,2,FALSE)


Does that help?

Steve


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