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
Bookmarks