IF function

C

carlito_1985

Hi all,

Is there anyway to incorporate a wildcard funtion into an IF function?

What I was planning on doing is something along the lines of


a b c
1 alan smith
2 john smith
3 graeme grey

what id like to do is
if(a1=*"smith"....)
but can't work out how?

is there anyway to use a wildcard in functions?

THanks
 
Top