Thread: Search Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Search Function

Try something like this:

Sheet2!A1:A100 contains various text, some of which may contain 1000_hc45

On Sheet1
A1: 1000_hc45

This formula returns TRUE if at least
one cell in Sheet2!A1:A100 includes the text in A1:
B1: =COUNTIF(Sheet2!A1:A100,"*"&A1&"*")0

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Manos" wrote in message
...
Dear all

i have in sheet 1 -- A1 an account 1000_hc45

in sheet 2 in column A and in300 lines i have formulas which import from
txt
and showed as : 1000_hc45+#1000_hc100+#1000_reg

There is any way to track in sheet 1 if the account of A1: 1000_hc45 exist
in any part of sheet 2 Column A?

Just ot find the account in the text, exact the same account.

Thanks in advance
Manos