Quite honestly ... without real-life examples .... it is rather difficult to visualize the challenges you are facing ...
It could very well be that you are confronted with situations more complex than ' regular ' partial matches ...
If that is the case, you should consider fuzzy logic ... and probably use the following add-in :
Hope this will help
Thanks for your help, found this on Mrexcel forum and it works;
If InStr(1, dataArray(i, searchField), searchValue, vbTextCompare) > 0 Then
With a Option Compare Text at the start.
Thank you again for the help