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
Solved! Go to Solution.
IIF(Contains([Name A], [Name B]), 'Contains', 'No Match')
IF Contains([Name A], [Name B]) THEN 'Contains' ELSE 'No Match' ENDIF