From bychua.imh@gmail.com@21:1/5 to All on Sat Jun 27 10:37:54 2020
Hi
I am more used to exact search using Vlookup / Search function etc.
But i have just been give an excel spreadsheet with long list of names.
I am supposed to check whether these names appear in a masterlist
As expected, eg
COL1
=========
Daniel A. Smith
John B Rani
Cruz Bill
Master List in another sheet
=============================
Daniel Ang Smith
Bill Cruz
Is there any function/formula i can write such that
If search(col1, in Master List range of cells) , if the row contains a word that can be found in the Range of cells in Master List, return True
Eg Daniel A. Smith should return a True since "Daniel" appears in master List. "John B Rani" will return False, "Cruz Bill" will return True.