Matching Text

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I have 2 lists of movies. List #1 consists of movies
currently available from my cable supplier. List #2
consists of movies I wish to see. I want to conduct a
search on List #1 for EACH movie in List#2
 
Assuming:

List #1 is in col A, A2 down
List #2 is in col B, B2 down

and no duplicates in List #1

Put in C2:
=IF(ISNA(ROW(OFFSET($A$1,MATCH(TRIM(B2),A:A,0)-1,0,1,1))),"--",ROW(OFFSET($A
$1,MATCH(TRIM(B2),A:A,0)-1,0,1,1)))

Copy C2 down as many rows as List #2 holds

Col C will return the row# of movies in List #1 which match those in List #2

(Unmatched movies in List #2 will be flagged with "--" in col C)
 
Back
Top