If Error-If Search function to find a word in a range of cells (partial string match)

**kisstheskye11** · 01-22-2015, 05:47 PM

I need to find if the words in column A are anywhere in the sentences within column D. If for example the word "wine" is in column D, I need it to spit back "yes". The problem is it's not an exact cell match from column A to column D. Column D has sentences, not single words. So I need to find "wine" in the sentences.

Attached is an example.

Thank you in advance!

**JieJenn** · 01-22-2015, 05:59 PM

The formula will give you true and false but you can use IF function to convert to yes or no. In B2, enter =NOT(ISERR(SEARCH(A2,$C$2:$C$10))) then fill the formula.

**Haseeb Avarakkan** · 01-22-2015, 06:13 PM

You could use MATCH with wildcard,

=IF(ISNUMBER(MATCH("*"&A2&"*",C:C,0)),"Yes","No")

**daddylonglegs** · 01-22-2015, 06:21 PM

Another possibility is to use COUNTIF with wildcards like this

=IF(COUNTIF(C:C,"*"&A2&"*"),"Yes","No")

If Error-If Search function to find a word in a range of cells (partial string match)

LinkBack

Thread Tools

Rate This Thread

Display

If Error-If Search function to find a word in a range of cells (partial string match)

Re: If Error-If Search function to find a word in a range of cells (partial string match)

Re: If Error-If Search function to find a word in a range of cells (partial string match)

Re: If Error-If Search function to find a word in a range of cells (partial string match)

Thread Information

Users Browsing this Thread

Similar Threads

Search variable number of sheets to find partial match on name

[SOLVED] VBA function to search partial string and return value

[SOLVED] Partial String Match in COUTIF Criteria Range?

[SOLVED] Vlookup, Match (Search or Find) partial string within string in a Cell

[SOLVED] Search for a partial string match and cycle through matching results

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions