|
Match Names in columns then copy associated info from 2 sheets
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 |
Match Names in columns then copy associated info from 2 sheets
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 |
Match Names in columns then copy associated info from 2 sheets
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" wrote: It does not seem to work?? "Michael" wrote: 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 |
Match Names in columns then copy associated info from 2 sheets
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 "Michael" wrote: 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" wrote: It does not seem to work?? "Michael" wrote: 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 |
| All times are GMT +1. The time now is 10:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com