Hey there, I have a work related issue where I'm trying to find common entries on two different sheets in numbers. I know of the match and lookup functions but I'm not entirely sure how to use them, especially with the dilemma I have. I possess one list of referrals that has individual names in the format (First name) (Last name) in separate columns. I have concatenated them in another column to match the layout in the other sheet I have of current clients. However, the current clients list sometimes possesses names with that are in a (Husband & Wife Last_Name) format, and so trying to match between the two would be difficult I would think. I'm trying to figure out how to either search via comparing the first list and searching within the entries of the second list and providing a third sheet with those names or at least get a check mark in another column or something that indicates that those values are shared between lists. I hesitate to simply remove one of the names from the current client list because I do not know which of the two would have been the ones to request a quote and thus would be in the referral list. I suppose I could Separate via disconcatenation (? not sure what command this is, separation?) and add even more entries to the list. I'm already dealing with 5760 clients in the current client list and 685 in the referral list. Any help would be greatly appreciated and I can provide further information if that will help. Thank you!