| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match Names in columns then copy associated info from 2 sheets
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| I want to match and insert info on 2 different sheets | New Users to Excel | |||
| match names in 2 different columns | Excel Discussion (Misc queries) | |||
| How can I match up values from 2 sheets and info in adjoining cell | Excel Discussion (Misc queries) | |||
| Copy info from worksheet 1 to other sheets | Excel Worksheet Functions | |||
Linear Mode
