Match cell values to column range for two respective columns

[nomnomster]

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

 

[seguin85]

Naomi,

Assuming your data starts in cell A2, try this in cell E2:

=IF(SUMPRODUCT(--((A2&B2)=($C$2:$C$9&$D$2:$D$9)))>0,"active","inactive")

and drag down column E. $C$2:$C$100&$D$2:$D$100 will need to be changed based on your how far down your data is in column C and D.

 

[nomnomster]

That's perfect. Thanks!!