| 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 |
| 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 | |||
Threaded Mode
