Hello,

I'm using this array formula

=ISNUMBER(LOOKUP(2^15,SEARCH(" "&TABLES!A:A&" "," "&SUBSTITUTE(SUBSTITUTE(C2,".",""),"-"," ")&" "))) (courtesy: benishiryo).

for a set of data of 15000 columns . Can any one suggest an alternative for this so that it calculate faster.