Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching columns
I want to know if there is a formula I can use that would match up the
same names from the 2 columns and put it in the same row with their results (i don't know if i'm explaining this correctly), instead of doing it manually. See below: Thanks! A B C D Charles 1 Peter 4 Peter 2 Xavier 3 Allison 3 Kim 7 Xavier 5 Nancy 6 Nancy 6 Edward 8 Edward 7 Pedro 9 Susan 8 Carlos 9 Kim 9 This is what I want it to look like: A B C D Charles 1 Peter 2 Peter 4 Allison 3 Xavier 5 Xavier 3 Nancy 6 Nancy 6 Edward 7 Edward 8 Susan 8 Kim 9 Kim 7 Carlos 9 Pedro 9 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching columns
"Peter" wrote: I want to know if there is a formula I can use that would match up the same names from the 2 columns and put it in the same row with their results (i don't know if i'm explaining this correctly), instead of doing it manually. See below: Thanks! A B C D Charles 1 Peter 4 Peter 2 Xavier 3 Allison 3 Kim 7 Xavier 5 Nancy 6 Nancy 6 Edward 8 Edward 7 Pedro 9 Susan 8 Carlos 9 Kim 9 This is what I want it to look like: A B C D Charles 1 Peter 2 Peter 4 Allison 3 Xavier 5 Xavier 3 Nancy 6 Nancy 6 Edward 7 Edward 8 Susan 8 Kim 9 Kim 7 Carlos 9 Pedro 9 In column c you can use the formula "vlookup(A1,$A$1:$A$8,1,0) now you will get the name in column c just drag it till the last row of names. then filter the not applicables and copy paste the names in column A manually to colunn c. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching 2 columns | Excel Worksheet Functions | |||
matching on columns | Excel Discussion (Misc queries) | |||
Matching Adjacent Columns? | Excel Worksheet Functions | |||
MATCHING COLUMNS | Excel Discussion (Misc queries) | |||
Matching two columns and their data | Excel Worksheet Functions |