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