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
bob 234 Oak St
pete 345 pine St

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

Michael Arch.




"Seantastic" wrote:

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
john
bob

Result that I want:
list1
john 123 Elm St
bob 234 Oak St
pete 345 pine St