Match Names in columns then copy associated info from 2 sheets

[Seantastic]

I have sheet "list1" which has a list (column) of names and their adresses
next to them.
I have another sheet "list2" which has the same names in a different order
and their e-mails next to them.
I want to excel to match then names between both sheet (look-up and match)
and then transpose the e-mail from "list2" to the same name on "list1" in a
blank column.

Example
list1
john 123 Elm St
bob 234 Oak St
pete 345 pine St

list2
pete (e-mail address removed)
john (e-mail address removed)
bob (e-mail address removed)

Result that I want:
list1
john 123 Elm St (e-mail address removed)
bob 234 Oak St (e-mail address removed)
pete 345 pine St (e-mail address removed)

 

[Michael]

Use the vlookup function
in your example lets assume you have the names in A1:A3 and the addres in
B1:B3
in C1 you key in: =VLOOKUP(A1,List2!A1:B3,2,FALSE)
You should get what you want:
john 123 Elm St (e-mail address removed)
bob 234 Oak St (e-mail address removed)
pete 345 pine St (e-mail address removed)

Assume List2 is the name of the Sheet

 

[Seantastic]

It does not seem to work??

Use the vlookup function
in your example lets assume you have the names in A1:A3 and the addres in
B1:B3
in C1 you key in: =VLOOKUP(A1,List2!A1:B3,2,FALSE)
You should get what you want:
john 123 Elm St (e-mail address removed)
bob 234 Oak St (e-mail address removed)
pete 345 pine St (e-mail address removed)

Assume List2 is the name of the Sheet
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

 

[Michael]

could you elaborate...
You must consider this:
a) john, bob and pete are in a column by themselves
b) The address is in a separate column
c) The string to compare must be exact

If it is not working, try it in a smaller scale, in my example I only have
the data you show in two different worksheets; and it works just fine.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

 

[Seantastic]

I reposted exactly what I am trying to do. I tried to simplify it for this
post but I guess it didn't work. - See Subject: Look Up march and copy info
back - Help! confused