Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another question regarding matching names and adding spaces
I have a new question that goes along with this. Is there a way to expand on
the cell selection? Besides the names in Column B, I also have data in Columns C, D, E, & F that I need to keep with the names in Column B. Thanks Again! "Xt" wrote: On Feb 13, 10:28 am, ILunacy wrote: I hope someone can help me out with this. Say I have column A filled with like 500 names, and column B filled with 300 of the same names. Is there a way or a formula to match the names in column B to the corresponding names in column A, move the name in B to be in the same row as the name in A, and to insert blank cells into B where there are no names to match A? Example: A B Abe Abe Brad Brian Brian Chris Chris changed to: A B Abe Abe Brad Brian Brian Chris Chris Thanks Try this in C1 =IF(ISNA(VLOOKUP(A1,B:B,1,0)),"",VLOOKUP(A1,B:B,1) ) and copy down to give the column you want. xt . |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another question regarding matching names and adding spaces
Formula has been modifed, copy down and across now as needed.
=IF(COUNTIF($B:$B,$A1)=0,"",VLOOKUP($A1,$F:$F,COLU MN(B1))) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ILunacy" wrote: I have a new question that goes along with this. Is there a way to expand on the cell selection? Besides the names in Column B, I also have data in Columns C, D, E, & F that I need to keep with the names in Column B. Thanks Again! "Xt" wrote: On Feb 13, 10:28 am, ILunacy wrote: I hope someone can help me out with this. Say I have column A filled with like 500 names, and column B filled with 300 of the same names. Is there a way or a formula to match the names in column B to the corresponding names in column A, move the name in B to be in the same row as the name in A, and to insert blank cells into B where there are no names to match A? Example: A B Abe Abe Brad Brian Brian Chris Chris changed to: A B Abe Abe Brad Brian Brian Chris Chris Thanks Try this in C1 =IF(ISNA(VLOOKUP(A1,B:B,1,0)),"",VLOOKUP(A1,B:B,1) ) and copy down to give the column you want. xt . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another question regarding matching names and adding spaces
A simple index/match will deliver all to you ..
Let's say your data in cols B to E, where col B = names to be matched with the base list in col A cols C to E are data associated with the names in col B Put in say, G1: =IF(ISNA(MATCH($A1,$B:$B,0)),"",INDEX(B:B,MATCH($A 1,$B:$B,0))) Copy G1 across to J1, fill down as far as required. Celebrate it, hit the YES below -- Max Singapore --- "ILunacy" wrote: Is there a way to expand on the cell selection ? Besides the names in Column B, I also have data in Columns C, D, E, & F that I need to keep with the names in Column B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching names and inserting spaces | Excel Worksheet Functions | |||
Matching names and inserting spaces | Excel Worksheet Functions | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Adding Spaces to the end of a value | Excel Worksheet Functions | |||
Matching when spaces are involved | Excel Worksheet Functions |