IF function
 

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


--
carlito_1985
------------------------------------------------------------------------
carlito_1985's Profile: http://www.excelforum.com/member.php...o&userid=21390
View this thread: http://www.excelforum.com/showthread...hreadid=474054

Hi,

This formula should be ok for what you want :

=IF(ISERROR(FIND("smith";A1));"Found";"Not found")

(depending on your language settings, replace the <; by <,)


Bye


--
Marco 66
------------------------------------------------------------------------
Marco 66's Profile: http://www.excelforum.com/member.php...o&userid=27909
View this thread: http://www.excelforum.com/showthread...hreadid=474054