Hi Folks,

I try to do the following:
I have 2 tables with one common column A (name), however the records
are not in the same range. I want to compare both tables and to get as
a result in a 3rd table: column A(name), column C(birthday) and column
B (city).
I think I should use vlookup function, I made some attempts but was not
successful yet. Could someone help me ?
It would be great !
thanks,


1st sheet :
column A(name) column B (age) column C(birthday)
george 25 1 may
dan 36 5 may
brian 42 18 may
rick 18 8 may
rene 29 14 april
david 31 23 march
jack 25 28 april

2nd sheet :
column A(name) column B(city)
george washington
rick new-york
rene london
jack berlin
david stuttgart
brian paris
dan roma


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=540226