need help urgent

Using 'Search' function with wildcard to find matching data in column of
another worksheet eg

search("mat*",'anotherExcel.xls'!Suppliers)

formula does not recurse through column

Is there a way i can overcome this or is there another formula or method I
could apply

Thanks