Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup for two lists from different sources
I have two sets of lists. Each contains names of companies. The problem is
that the lists come from two sources, and thus are not the exact same (i.e. some have Co., Inc., etc.). I need to make these names match on both lists? How can I do this? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup for two lists from different sources
Sometimes, only manually. But for some cases, you can use a function that returns an index that can
be used to find some close matches. Visit http://www.j-walk.com/ss/excel/tips/tip77.htm for details. HTH, Bernie MS Excel MVP "ExcelQuestion" wrote in message ... I have two sets of lists. Each contains names of companies. The problem is that the lists come from two sources, and thus are not the exact same (i.e. some have Co., Inc., etc.). I need to make these names match on both lists? How can I do this? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup for two lists from different sources
You can get rid of some of them by using the Replace (Ctrl+H), enter the
"Co." and if you just want to delete it then don't type in the replace line but do click on it, then replace or replace all - you can do this to both lists so that they are the same... or combine into one sheet and sort so that similar names are together, and then use auto fill or delete... I'm not sure if you are trying to get to a single list ... -- ~Christine, CPA "ExcelQuestion" wrote: I have two sets of lists. Each contains names of companies. The problem is that the lists come from two sources, and thus are not the exact same (i.e. some have Co., Inc., etc.). I need to make these names match on both lists? How can I do this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-down lists in vlookup | Excel Discussion (Misc queries) | |||
VLOOKUP and Multi Lists | New Users to Excel | |||
VLOOKUP and Multi Lists | Excel Worksheet Functions | |||
Vlookup - Comparing two lists in different worksheets | Excel Worksheet Functions | |||
Problem with VLOOKUP and drop-down lists! | Excel Worksheet Functions |