you want that Table 1 should consist of three columns
i-e Userid, Name & Email
suppose Userid is in col A, Email in col B
click on any cell in col B and add a col (menu Insert columns) and
give it heading "Name".
in this new col which is now col B put following formula.
=VLOOKUP(A1,$D$1:$E$50,2,FALSE)
in this formula range $D$1:$E$50 is where your Table 2 data is.
you should change the references according to your data.

hope this would serve the purpose.

watz Wrote:
Hi,
I'm wondering how do i combine 2 tables. For example I have in:
Table 1: Userid + Email
Table 2: Userid + Name

I would like to put the Name field in Table 2 into Table 1 so that
Table 1 consists of Userid, Name & Email. Any idea how do I do that in
Excel? What Excel function do I use?

Thanks in advance for your help!


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=569365