nomnomster
New Member
- Joined
- Oct 22, 2014
- Messages
- 18
Hello!
I'm trying to check when patient names from one list, split in two columns (one for first name and one for last name), match up with another list of names, also split in two columns. Here's what it looks like:
Column A: First Names Column B: Last Names Column C: First Names Column D: Last Names Column E: Active or Inactive
I need to know when a name from columns C&D matches up with a name from columns A&B. Ideally, I'd like column E to indicate "active" if there's a match or "inactive" if there isn't.
*One last note which probably plays into things: columns C&D are linked so that all cell values are pulled from another workbook.
Let me know if there's anything else I can clarify.
Thanks for any help
Naomi
I'm trying to check when patient names from one list, split in two columns (one for first name and one for last name), match up with another list of names, also split in two columns. Here's what it looks like:
Column A: First Names Column B: Last Names Column C: First Names Column D: Last Names Column E: Active or Inactive
I need to know when a name from columns C&D matches up with a name from columns A&B. Ideally, I'd like column E to indicate "active" if there's a match or "inactive" if there isn't.
*One last note which probably plays into things: columns C&D are linked so that all cell values are pulled from another workbook.
Let me know if there's anything else I can clarify.
Thanks for any help
Naomi