how do I allow a VBA search to not look for only exact matches

I have this code,

If ((dataArray(i, *searchField*) = *searchValue*) Then

Which is not working. what I am trying to achieve is;

if all of search value is in any part of search field or vice versa then do X

Any help?