Thread
:
Finding text
View Single Post
#
3
March 5th, 2009, 08:25 AM posted to microsoft.public.excel.newusers
DILipandey
external usenet poster
Posts: 69
Finding text
Hi John,
Assuming the text you want to search is there in Cell C1, and the data in
which search is to be conducted is there in Column A, Now use the following
formula:-
=IF(ISNUMBER(MATCH("*"&TEXT(C1,"@")&"*",$A:$A,0)), "Name Is There","Name Is
Not There")
Let me know if it works.. Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
New Delhi, India
"JOHN" wrote:
I am using Excel 2007, I have a column containing formulas that would return
a name if true and a zero if false. I want to search the column for the text
entry and return that text as the answer. Can I do this or should the column
formulas be changed to something else? The "T" formula seems to work only
for one cell not the whole column.
DILipandey
View Public Profile
View message headers
Find all posts by DILipandey
Find all threads started by DILipandey