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
|