search a row for a word and if found

V

Vibeke

I have 4 columns (C to F) I need to search row by row for a particular word.
If the word is found in a row, I need to return 1 in Column G or 0 if not
found. I've tried various iterations of IF\SEARCH\MATCH and so on. The four
columns contain address lines, i.e. a mixture of text and numbers and the
word can appear in any of the columns, at any place in the string. I'd prefer
if it weren't case sensitive but it's not imperative. Many thanks in
anticipation!
 
J

Jacob Skaria

Try the below

=IF(COUNTIF(C4:F4,"*findword*"),1,0)

'with the query word in cell A1
=IF(COUNTIF(C4:F4,"*" & A1 & "*"),1,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to seacrh for a word across multiple columns 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Formula to search for a word and put that entire row in a list 3
IF formula, Partial word, SUM function as result 1
Link an entire Row with a Key Word 1
Searching for a word and then copy the whole row 5
Search for a particular letter in the sentence and print 4
using the =page! feature to transpose a row to column 0

Top