Thread: Search Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manos Manos is offline
external usenet poster
 
Posts: 50
Default Search Function

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