Searching a String for a Matching Word from another String
Determining whether the first word from each string in column A appears within the corresponding string in the same row of column B.
Use the IF, ISNUMBER, FIND, and LEFT functions as shown in the following formula:
=IF(ISNUMBER(FIND(LEFT(A2,FIND(\" \",A2)-1),B2)),\"1st Word Found\",\"1st Word Not Found\")
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1