allow search on ranges of values
 

Hi all

I like to create a formula that will do wildcard searches for each
individual field of a worksheet

for ex

if i have a column with 10 row (E1:E10)
and like to apply a similar formula for each

(A1 = dar, A2 = case)

search(A1*, 'anotherWorksheet.xls'!Column)
search(A2*, 'anotherWorksheet.xls'!Column)

how can i go about removing the wildcard errors