Hi, I have four columns of data (C-F) I need to search for a particular word.
The data is addresses, i.e. it combines text and numbers and the word I'm
searching for can appear anywhere within it (or not at all). The function I
require will return 1 if it does and 0 if it does not. Have tried various
iterations of if\search\match and so on to no avail - perhaps because I'm
searching a range of columns rather than a specific cell? I'd appreciate your
suggestions. Regards,