Very good!

--
Biff
Microsoft Excel MVP


"Jai" wrote in message
...

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