Spreadsheet: 57362d1257454910-match-text-string-with-other-text-string-sample-1-
Sheet: Sheet1

Song | LOOKUP(9.99999999999999E+307,CHOOSE({1,2},"",formula) | Match in column A | Match in column B |  | Prior Match
Fireflies, Owl City | 21 Guns, Green Day | 0 | 28 |  | 29
[NAME], [NAME] | 3, Britney Spears | 21 | 95
Down, [NAME] | Ain't No Rest For The Wicked, Cage The Elephant | 0 | 21
Party In The U.S.A., [NAME] | All The Right Moves, OneRepublic | 0 | 66
Run This Town, Jay-Z, Rihanna & Kanye West | Already Gone, [NAME] | 0 | 70
Paparazzi, [NAME] | American Ride, [NAME] | 0 | 64
Meet Me Halfway, The Black Eyed Peas | Bad Habits, Maxwell | 0 | 56
3, Britney Spears | Be On You, Flo Rida Featuring Ne-Yo | 0 | 3
I Gotta Feeling, The Black Eyed Peas | Big Green Tractor, [NAME] | 0 | 43
[NAME], Beyonce | Body Language, Jesse McCartney Featuring T-Pain | 0 | 81
You Belong With Me, [NAME] | Bonfire, [NAME] | 0 | 100
Replay, Iyaz | Boom Boom Pow, The Black Eyed Peas | 0 | 69
Empire State Of Mind, Jay-Z + [NAME] | Break Up, [NAME] Gucci Mane & [NAME] | 0 | 23
Forever, Drake Featuring [NAME], Lil Wayne & Eminem | Break, Three Days Grace | 0 | 29
Use Somebody, Kings Of Leon | Bust A Move, [NAME] Featuring [NAME] | 0 | 91
[NAME], [NAME] Featuring Akon | Consider Me Gone, Reba | 0 | 74
Already Gone, [NAME] | [NAME], [NAME] | 0 | 6
Need You Now, [NAME] | Do I, [NAME] | 0 | 58
Obsessed, [NAME] | Doesn't [NAME], [NAME] | 0 | 61
[NAME], [NAME] | Down, [NAME] | 0 | 95
[NAME], [NAME] | Drop It Low, Ester Dean Featuring [NAME] | 0 | 18
[NAME], Ke$ha | Empire State Of Mind, Jay-Z + [NAME] | 0 | 86
Break Up, [NAME] Gucci Mane & [NAME] | Evacuate The Dancefloor, Cascada | 0 | 14
I Can Transform Ya, [NAME] Featuring Lil Wayne & Swizz Beatz | Face Drop, [NAME] | 0 | 42
Toes, [NAME] | Fallin' For You, [NAME] | 0 | 88
Fallin' For You, [NAME] | Fifteen, [NAME] | 0 | 26
Say Hey (I Love You), [NAME] Anderson | Fireflies, Owl City | 0 | 73
Love Drunk, Boys Like Girls | Forever, Drake Featuring [NAME], Lil Wayne & Eminem | 0 | 55
Evacuate The Dancefloor, Cascada | Funhouse, Pink | 0 | 24
Throw It In The Bag, Fabolous Featuring The-Dream | [NAME], Snoop Dogg Featuring The-Dream | 0 | 84
Papers, Usher | Gettin' You Home (The Black Dress Song), [NAME] | 0 | 65
Hotel Room Service, [NAME] | God In Me, [NAME] "KiKi" Sheard | 0 | 41
She [NAME], Shakira | [NAME], Cobra Starship Featuring Leighton Meester | 0 | 75
[NAME], [NAME] Featuring [NAME] | Good Morning, Chamillionaire | 0 | 80
Gettin' You Home (The Black Dress Song), [NAME] | Happy, [NAME] | 0 | 32
Only You Can Love Me This Way, Keith Urban | Haven't Met You Yet, [NAME] | 0 | 63
Wasted, [NAME] Or OJ Da Juiceman | Hey, Soul Sister, Train | 0 | 93
Drop It Low, Ester Dean Featuring [NAME] | History In The Making, [NAME] | 0 | 22
[NAME], Cobra Starship Featuring Leighton Meester | Honky Tonk Stomp, Brooks & Dunn Featuring Billy Gibbons | 0 | 34
21 Guns, Green Day | Hotel Room Service, [NAME] | 0 | 2
Do I, [NAME] | I Can Transform Ya, [NAME] Featuring Lil Wayne & Swizz Beatz | 0 | 19
Welcome To The Future, [NAME] | I Gotta Feeling, The Black Eyed Peas | 0 | 94
I Know You Want Me ([NAME]), [NAME] | I Invented Sex, [NAME] Featuring Drake | 0 | 45
Who Says, [NAME] | I Know You Want Me ([NAME]), [NAME] | 0 | 99
Boom Boom Pow, The Black Eyed Peas | I Wanna Make You Close Your Eyes, Dierks Bentley | 0 | 13
Successful, [NAME] Trey Songz & Lil Wayne | I Want To Know What Love Is, Mariah Carey | 0 | 79
Knock You Down, [NAME] Featuring Kanye West & Ne-Yo | I Will Not Bow, [NAME] | 0 | 52
I'm Alive, [NAME] With [NAME] | I'm Alive, [NAME] With [NAME] | 0 | 49
Big Green Tractor, [NAME] | I'm Going In, Drake Featuring Lil Wayne & Young Jeezy | 0 | 10
Time For Miracles, [NAME] | [NAME] (Everywhere We Are), [NAME] | 0 | 87
Never Say Never, The Fray | Knock You Down, [NAME] Featuring Kanye West & Ne-Yo | 0 | 59
[NAME] (Everywhere We Are), [NAME] | [NAME], LMFAO | 0 | 51
American Ride, [NAME] | LOL :-), [NAME] Gucci Mane & Soulja Boy Tell'em | 0 | 7
Body Language, Jesse McCartney Featuring T-Pain | Love Drunk, Boys Like Girls | 0 | 11
Funhouse, Pink | Meet Me Halfway, The Black Eyed Peas | 0 | 30
Hey, Soul Sister, Train | Money To Blow, Birdman Featuring Lil Wayne & Drake | 0 | 38
[NAME], Snoop Dogg Featuring The-Dream | Need You Now, [NAME] | 0 | 31
Smile, Uncle Kracker | Never Say Never, The Fray | 0 | 76
Be On You, Flo Rida Featuring Ne-Yo | Number One, R. Kelly Featuring [NAME] | 0 | 9
Doesn't [NAME], [NAME] | Obsessed, [NAME] | 0 | 20
Southern Voice, [NAME] | One Less Lonely Girl, [NAME] | 0 | 77
Fifteen, [NAME] | Only You Can Love Me This Way, Keith Urban | 0 | 27
Good Morning, Chamillionaire | Paparazzi, [NAME] | 0 | 35
Money To Blow, Birdman Featuring Lil Wayne & Drake | Papers, Usher | 0 | 57
Face Drop, [NAME] | Party In The U.S.A., [NAME] | 0 | 25
Uprising, Muse | Red Light, [NAME] | 0 | 90
Consider Me Gone, Reba | Regret, LeToya Featuring Ludacris | 0 | 17
All The Right Moves, OneRepublic | Replay, Iyaz | 0 | 5
Number One, R. Kelly Featuring [NAME] | Run This Town, Jay-Z, Rihanna & Kanye West | 0 | 60
Starstrukk, 3OH!3 Featuring [NAME] | Runaway, Love And Theft | 0 | 78
Runaway, Love And Theft | [NAME], Rihanna | 0 | 71
I'm Going In, Drake Featuring Lil Wayne & Young Jeezy | Say Hey (I Love You), [NAME] Anderson | 0 | 50
I Wanna Make You Close Your Eyes, Dierks Bentley | [NAME], [NAME] Featuring Akon | 0 | 46
God In Me, [NAME] "KiKi" Sheard | She [NAME], Shakira | 0 | 33
Red Light, [NAME] | Smile, Uncle Kracker | 0 | 67
Bonfire, [NAME] | Southern Voice, [NAME] | 0 | 12
I Will Not Bow, [NAME] | Starstrukk, 3OH!3 Featuring [NAME] | 0 | 48
Haven't Met You Yet, [NAME] | Successful, [NAME] Trey Songz & Lil Wayne | 0 | 37
[NAME], LMFAO | [NAME], [NAME] Featuring [NAME] | 0 | 53
Take Your Shirt Off, T-Pain | [NAME], Beyonce | 0 | 82
Bad Habits, Maxwell | Take Your Shirt Off, T-Pain | 0 | 8
One Less Lonely Girl, [NAME] | Temporary Home, [NAME] | 0 | 62
Ain't No Rest For The Wicked, Cage The Elephant | Throw It In The Bag, Fabolous Featuring The-Dream | 0 | 4
Under, Pleasure P | Tie Me Down, New Boyz Featuring Ray J | 0 | 89
LOL :-), [NAME] Gucci Mane & Soulja Boy Tell'em | [NAME], Ke$ha | 0 | 54
White Liar, [NAME] | Time For Miracles, [NAME] | 0 | 98
Tie Me Down, New Boyz Featuring Ray J | Toes, [NAME] | 0 | 85
Break, Three Days Grace | Under, Pleasure P | 0 | 15
Wheels, Foo Fighters | Uprising, Muse | 0 | 97
I Invented Sex, [NAME] Featuring Drake | Use Somebody, Kings Of Leon | 0 | 44
Regret, LeToya Featuring Ludacris | [NAME], Owl City | 0 | 68
Temporary Home, [NAME] | Wasted, [NAME] Or OJ Da Juiceman | 0 | 83
Bust A Move, [NAME] Featuring [NAME] | Welcome To The Future, [NAME] | 0 | 16
You're A Jerk, New Boyz | [NAME], [NAME] | 0 | 101
[NAME], Owl City | [NAME], [NAME] | 0 | 92
Honky Tonk Stomp, Brooks & Dunn Featuring Billy Gibbons | Wheels, Foo Fighters | 0 | 40
I Want To Know What Love Is, Mariah Carey | White Liar, [NAME] | 0 | 47
Happy, [NAME] | Who Says, [NAME] | 0 | 36
History In The Making, [NAME] | You Belong With Me, [NAME] | 0 | 39
[NAME], Rihanna | You're A Jerk, New Boyz | 0 | 72