can you please attach the sample workbook On Tue, Feb 15, 2011 at 11:58 PM, MikeMikeMike <michael.lovel...@gmail.com>wrote:
> Say for example I have one tab that has a list of contact information > - say anywhere from 1000 to over 100,000 contact items that include > name (one field for first and last name), phone, address, etc. > > On the other tab I have a list of Categories. 1 column for Category > Name and the other for a text identifier that is unique to that > Category. > > Something like this: > > A column of Worksheet 1: > Michael Lovelady > Steve Smith > Jonathan Lovelady > Phillip Lovelace > > A & B columns of 1st row of Worksheet 2 (hyphen separated): > Love - lov > > What I want to do is add an additional column to Worksheet 1 that does > a vlookup (or something similar?) to match text specified in worksheet > 2 (column B) and if it matches to return the Category Name specified > in column A. > > I basically have tons of data that I need to segment on an ongoing > basis and am looking for a good way to do it. > > Many thanks to anyone who can help! > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel