Creating a true/false column to indicate partial word matches between two columns

Question

New to excel. I have tried using the VLOOKUP and IF function to find the best solution. However, I am struggling to get the partial match aspect down. I also want the partial match to include any spaces after the words.

Example

Column1  Column2    Column3
dog      cat        No Match
house    house(big) Match
cat      cat        Match

I have tried using the trim, VLOOKUP, and IF functions.

so, you need "partial Match" as a result of comparing house and house(big)? — Horaciux, May 09 '23 at 18:50

score 2 · Answer 1 · answered May 09 '23 at 18:50

2

use SEARCH:

=ISNUMBER(SEARCH(A1,B1))

answered May 09 '23 at 18:50

Scott Craner

148,073
10
49
81

score 1 · Answer 2 · answered May 09 '23 at 18:51

1

Assuming you need "partial Match" as a result of comparing house and house(big)

=IF(A2=B2, "Match", IF(ISNUMBER(SEARCH(A2, B2)), "Partial Match", "No Match"))

answered May 09 '23 at 18:51

Horaciux

6,322
2
22
41

Creating a true/false column to indicate partial word matches between two columns

2 Answers2