Thread: Need a formula to 'find' word in cells of column from a long list
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jai jai is offline
external usenet poster
  
Posts: 71
Default Need a formula to 'find' word in cells of column from a long l

Never mind, figured it out. For those interested

=IFERROR(INDEX($A:$A,SMALL(IF(ISNUMBER(SEARCH(TRIM ($B1),$A$1:$A$500)),ROW($A$1:$A$500),""),?)),"")

entred as an array where ? is the number of the result. So the first column
giving the first match would have ?=1, the second column giving the second
match would have ?=2, etc

enjoy
Reply With QuoteReply With Quote