How to match two strings

[Saravanan13]

Hello All,

I am looking to match two names name1 and name2, Even when the name is reversed the outcome should should say match.

Can anyone assist.

Name1	Name2
Mohit Sharma	Sharma Mohit

[cjaneczko · Accepted solution]

Does this work?

[acarter881 · Accepted solution]

Hello, @Saravanan13.

Here's a way to do it in a single formula (see attached).

[flying008 · Accepted solution]

Hi, @Saravanan13 

Try this formula for field [Match] :

[Name1] = [Name2] || ( GetWord([Name1], 0) = GetWord([Name2], 1) && GetWord([Name1], 1) = GetWord([Name2], 0) )