Comparing two columns to see if any Text in Column A matches Column B

[Masond3]

HI All 

Long time 

I need some assistance 

Aim : Per row to validate if the name in column "Name b" is found within column "Name A"

I wrote the following formula "if contains([Name B],[Name A]") then "Contains" else "No Match" endif" however i am presented with an "Mal informed" error 

Example 

Name A	Name B	Outcome
Mason LTD	Fairstone Financial Management Ltd	No Match
PI Ltd	Countrywide	No Match
Intelligent Money Ltd	Intelligent Money	Contains
Alpha To Omega (UK) Limited - In Liquidation	Cyrpto	No Match
Raymond James Investment Services Ltd	Cyrpto	No Match
SW Funding plc	Cyrpto	No Match
Schroders Wealth & Investment	Schroders	Contains
Funky House Financial Fitness Ltd	Funky House Fitness Limited	Contains
HSBC- W&IM - UK	HSBC	Contains
Ironmarket Ltd	Boolers	No Match
David Booler & Co	Boolers	Contains
Blackstone Moregate Ltd	Ajax Wealth Management Ltd	No Match
Cartlidge Morland Ltd	Cartlidge Morland	Contains

Looking forward to your assistance

Regards
Masond3

[binu_acs · Accepted solution]

@Masond3 

IIF(Contains([Name A], [Name B]), 'Contains', 'No Match')

IF Contains([Name A], [Name B]) THEN 'Contains' ELSE 'No Match' ENDIF

[atcodedog05]

Hi @Masond3 

There is not needed quote here please remove it and it should work

And formula should be as below similar to as @binu_acs mentioned

Hope this helps : )