Does anyone know how to program a basic VBA IF statement using Contains.

Something like this: 

If cells(i,2).value contains cells(m,41).value then
I tried using this: 

If Cells(i, 2).Value = "*" & Cells(m, 41).Value & "*" Then
It ran the code without error but didn't seem to actually do what I wanted.