Attached excel sheet shows that a formula in column A is checking if there is a match between data in column D (cell 2 to 100) with content in column B.
If there is a match a check (v) is placed in column A. this works fine.
But I need also be able to check if the content matches partly. see attached sheet.
the lines which have a full match are checked. but the other lines contain at least the same content and even more.
All content are directory paths, I want all cell's to match if the content in column B contains one of the strings in column D.
If possible, I want to place the matching string in a cell in column A or C for example.