how to find one text i anather

Kikus · #1 07-20-2009, 05:16 AM

I am trying to write a formula with will check if some text is present in the other. I know that there is function with do that but I need a True or False answer but not a number of character. I will be very grateful for your help.

penghuipan · #2 08-17-2009, 11:33 PM

Hi Kikus,
I think use this formula will be get the value you wanted:
if(vlookup($a1,$b$1:$b$10,1,0),"true","false").

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help with find and replace	sjkiss	Word	1	04-12-2010 08:08 AM
Needs help to find excel formula- Please	aamer_1983	Excel	2	07-13-2009 01:46 AM
Find and Replace Macro - A Better Way	Tribos	Word VBA	0	10-08-2008 03:22 AM
Templates: automatic text generation from Rich Text content control	Chickenmunga	Word	0	10-01-2008 11:16 AM
Cells with wrap text not showing text	lazylew	Excel	1	08-31-2008 06:58 AM