Spreadsheet: 877904d1724846480-search-for-partial-matches-in-a-list-nunez100-example-v2-tms
Sheet: Sheet1 (Updated Range)

 |  |  |  |  | Sample edited to cause issue identified
Result |  |  |  |  | Input Data |  | TMS |  | AliGW |  |  |  |  |  |  |  |  | TMS v2
[NAME] |  |  |  |  | BANK GIRO CREDIT REF Parson
Nikita Smith |  |  |  |  | Transfer fia faster payment to Smith 465 |  | Nikita Smith |  | Nikita Smith |  |  |  |  |  |  |  |  | Nikita Smith
[NAME] |  |  |  |  | BANK GIRO CREDIT REF Henry 143 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
Nikita Smith |  |  |  |  | BANK GIRO CREDIT REF Smith |  | Nikita Smith |  | Nikita Smith |  |  |  |  |  |  |  |  | Nikita Smith
[NAME] |  |  |  |  | Transfer via faster payment to [NAME] |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  | BANK GIRO CREDIT REF [NAME] |  | *** check *** |  | Error |  |  |  |  |  |  |  |  | *** check ***
Jacinta [NAME] |  |  |  |  | BANK GIRO CREDIT REF Uppham 29 |  | Jacinta [NAME] |  | Jacinta [NAME] |  |  |  |  |  |  |  |  | Jacinta [NAME]
[NAME] |  |  |  |  | BANK GIRO CREDIT REF Maguire 463 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  | Direct Debit Payment to Perry 453 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Return Values | Search Term
[NAME] |  |  |  |  | BANK GIRO CREDIT REF Howie 309654 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  | BANK GIRO CREDIT REF Howie 309654 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Parson
[NAME] |  |  |  |  | Direct Debit Payment to Parson |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Nikita Smith | Smith
[NAME] |  |  |  |  | BANK GIRO CREDIT REF Maguire 463 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  | Transfer via faster payment to [NAME] |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Jacinta [NAME] |  |  |  |  | BANK GIRO CREDIT REF Uppham 29 |  | Jacinta [NAME] |  | Jacinta [NAME] |  |  |  |  |  |  |  |  | Jacinta [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Jacinta [NAME] | [NAME]
[NAME] |  |  |  |  | Direct Debit Payment to Maguire 463 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  | BANK GIRO CREDIT REF [NAME] |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Maguire
 |  |  |  |  |  |  | Original formula:
 |  |  |  |  |  |  | Nikita Smith
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Nikita Smith
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME],[NAME]
 |  |  |  |  |  |  | Jacinta [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Jacinta [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]