How to search string from one column in an adjacent column, display match in third?

[astrbac]

Hi all,

I have a pretty simple (or maybe not?) task to perform, in a small-ish spreadsheet.

Data is imported from two different software applications; one is a website form and another is an official "register" of a sort. In the register the names and last names are taken from ID's properly, in separate fields. On the website however, users enter a plethora of, well, "forms" of their names .

What I need to do is search for strings entered through a website form, in a dataset imported from the official register.

Final goal: count the number of matches; a simple numeric value, nothing else.

Example below, I hope this makes it a bit easier.
Many thanks in advance!

name (from App 1)	Name from (App 2)	Last name from (App 2)	match
John Smith	Marco Polo	The Third	FALSE
Steve Ivan Hoe	Jedi	Knight	FALSE
Janice Murphy	John	Smith	TRUE
Marc Anthony	Joao	Gilberto	TRUE
Gilberto Joao	Steve	Irvine	FALSE
	James Marshall	Hendrix	FALSE
	Little	Cat	FALSE

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[njimack]

Not quite sure what you're asking for, I presume you want a formulaic calculation in the Match column...
=OR(NOT(ISERROR(MATCH(B2&" "&C2,$A$2:$A$6,0))),NOT(ISERROR(MATCH(C2&" "&B2,$A$2:$A$6,0))))

 

[astrbac]

Yes, I need to find TRUE/FALSE in the "Match" column and then simply filter or count the number of "true"'s in that column. That's all



Thanks!