Simple "if word exist among theese cells, then true"

Im banging my head on the "find" functions. They give me a -value- when
I need TRUE/FALSE for an IF function.
It must be a much easier way to return TRUE or FALSE if a word exist
within an area:

Data:
A1: Orange
A2: Apple
A3: Banana

Function:
1: Is "*Apple*" in A1:A3? = TRUE!
2: Is "*Tomato*" in A1:A3? = FALSE!


-- 
JemyM
------------------------------------------------------------------------
JemyM's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26945
View this thread: http://www.excelforum.com/showthread.php?threadid=517716

0
3/1/2006 9:28:11 AM
excel 39879 articles. 2 followers. Follow

3 Replies
362 Views

Similar Articles

[PageSpeed] 15

=NOT(ISNA(VLOOKUP(B1,A1:A3,1,FALSE)))

-- 
Kind regards,

Niek Otten

"JemyM" <JemyM.23zi3z_1141205404.9896@excelforum-nospam.com> wrote in 
message news:JemyM.23zi3z_1141205404.9896@excelforum-nospam.com...
>
> Im banging my head on the "find" functions. They give me a -value- when
> I need TRUE/FALSE for an IF function.
> It must be a much easier way to return TRUE or FALSE if a word exist
> within an area:
>
> Data:
> A1: Orange
> A2: Apple
> A3: Banana
>
> Function:
> 1: Is "*Apple*" in A1:A3? = TRUE!
> 2: Is "*Tomato*" in A1:A3? = FALSE!
>
>
> -- 
> JemyM
> ------------------------------------------------------------------------
> JemyM's Profile: 
> http://www.excelforum.com/member.php?action=getinfo&userid=26945
> View this thread: http://www.excelforum.com/showthread.php?threadid=517716
> 


0
nicolaus (2022)
3/1/2006 10:05:43 AM
=COUNTIF(A1:A3,"*Apple*")>0

-- 
 HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JemyM" <JemyM.23zi3z_1141205404.9896@excelforum-nospam.com> wrote in
message news:JemyM.23zi3z_1141205404.9896@excelforum-nospam.com...
>
> Im banging my head on the "find" functions. They give me a -value- when
> I need TRUE/FALSE for an IF function.
> It must be a much easier way to return TRUE or FALSE if a word exist
> within an area:
>
> Data:
> A1: Orange
> A2: Apple
> A3: Banana
>
> Function:
> 1: Is "*Apple*" in A1:A3? = TRUE!
> 2: Is "*Tomato*" in A1:A3? = FALSE!
>
>
> -- 
> JemyM
> ------------------------------------------------------------------------
> JemyM's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=26945
> View this thread: http://www.excelforum.com/showthread.php?threadid=517716
>


0
bob.phillips1 (6510)
3/1/2006 10:41:38 AM
Bob Phillips Wrote: 
> =COUNTIF(A1:A3,"*Apple*")>0

Niek Otten Wrote: 
> =NOT(ISNA(VLOOKUP(B1,A1:A3,1,FALSE)))

Fantastic! Thanks guys :)


-- 
JemyM
------------------------------------------------------------------------
JemyM's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26945
View this thread: http://www.excelforum.com/showthread.php?threadid=517716

0
3/1/2006 11:53:52 AM
Reply:

Similar Artilces:

Simple "if word exist among theese cells, then true"
Im banging my head on the "find" functions. They give me a -value- when I need TRUE/FALSE for an IF function. It must be a much easier way to return TRUE or FALSE if a word exist within an area: Data: A1: Orange A2: Apple A3: Banana Function: 1: Is "*Apple*" in A1:A3? = TRUE! 2: Is "*Tomato*" in A1:A3? = FALSE! -- JemyM ------------------------------------------------------------------------ JemyM's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26945 View this thread: http://www.excelforum.com/showthread.php?threadid=517716 =N...