are you saying you want to do a "fuzzy" search?

yes i guess it would be a fuzzy search. In the bulit in advanced filter option
in excel there is an option to filter " contains". I wish to use that together
with looping.

i.e what the script should do is..

pick the first cell  in the column1 of a worksheet  (a1), then see if it (
the value of a1) is contained  in any cells  say of the column10 of worksheet2 or
to keep it simple of the same worksheet.

and if it finds a cell which 'contains' or 'exactly matches' (a1) then it
does some other action like pasting the adjacent cell into say b1 of workshhet2
or same worksheet or colors the adjacent cells red

Here is a function that may help. It is similar to Match(), but uses
InStr() to return the position of lookup_value in lookup_array if
lookup_value is contained  anywhere in the cells  of lookup_array.

Then, you can use INDEX() to get the identification number.


Function Match2(lookup_value, lookup_array)
n = 1
For Each c In lookup_array
If InStr(c, lookup_value) > 0 Then
Match2 = n
Exit Function
End If
n = n + 1
Next
Match2 = False
End Function

Can u give us more examples of different names?
Amount of characters?
Amount of words?
First word always the same?
First word always spelled correctly?