I want to compare two columns as shown below. Column A includes a list of film titles and the releasing years, which are in brackets. Column B includes a list of film titles without releasing years. I want to find out whether films in column B also show up in column A. If a film in column B is included in column A, then column C is recorded 1; otherwise 0.
I can't use the "if(iserror(match" formula, since the films in column B are not exactly the same as films in column A. Column A includes the releasing year while column B doesn't. In this case, how should I solve the problem?
Column A
A1: I Am Legend (2007)
A2: Fast Food Nation (2004)
A3: Transformers (2000)
Column B
B1: I am legend
B2: Crash
B3: Transformer
Column C
C1: 1
C2: 0
C3: 1
Bookmarks