Hi folks,
thanks for your help in advance.
I have a sheet with various (company) names in one column. In a different sheet, I have a list with names as well. Now I want to check, if the names from the first sheet are included in the second one.
If the names were exactly the same, I would use =if(countif()). Unfortunately, the names originate from two different sources, thus they might not be completely identical.
Is there a way to check this? If it were only one cell, that is concerned I guess, I coud use =isnumber(search()), but I have no idea how to apply this to a whole column.
Thanks again!
Bookmarks