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