Forum Discussion
Weird! "*" doesn't work sometimes?
With the help of this page community, I created the following formula which let me compare individual items in a column against a large list of data elements in another column where more often than n...
That's 256 characters limit. You may try instead
=IF(ISNA(MATCH(TRUE,INDEX(ISNUMBER(SEARCH(A1,Calculations!A:A)),0),0)), "Not Found","Matched")Performance is not as good as for the first formula, it's better to limit the range for Calculations sheet.