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