The "City Staff Meeting" will never come into play, because it will never b on table A. Table A, is only events for which my company sold tickets. Table B is all the events from the past year. I will need it to detect that "Drowsy Chaperone" is the same as "The Drowsy Chaperone". Also, there are several "North Carolina Symphony Events in Table A, and such in table B, I'd want the formula to pick up that each is different...such as "North Carolina Sym Disney" in table A would be the same as "North Carolina Symphony Presents The Magic of Disney" or whatever it says like such in table B. Or that "Storybook Theater Dora" from Table A is the same as "Dora the Explorer-Broadway series south" from table B. I do foresee some issues with this, but I'm trying to figure out a way around them as well. Thanks so much for your help.
Musicman715