If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Function to seacrh for a word across multiple columns
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, |
Thread Tools | |
Display Modes | |
|
|