Data Cleaning - help

[newexcler]

Dear Experts


I had to complete a huge excel cleaning job and was not provided time.

Please refer to the attached input and reference output tabs.
I have excel column, with names in various formats, I need to compare each cell of this with master database and if matching print the row number against column A.

What I tried:

I used Delimeter and split the dates, and combined based on date, segregated into another column, then I use VLOOKUP but its tedious as I have to do several steps because given name and surname is different.
Thank you in advance.


Input file
[TABLE="width: 956"]
<tbody>[TR]
[TD]Target to search ( each of the cell below) - Date format DD/MM/YY[/TD]
[TD]Search against this Coloumn[/TD]
[TD]Record 1D[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD] Tanya, Surname_25/12/18[/TD]
[TD]Names 1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]David Surname_11/12/12[/TD]
[TD]Names 2 Surname[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Surname kenny_10/08/12[/TD]
[TD]Surname Name 3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Surname, Thomas_12/06/19[/TD]
[TD]Name_Surname4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jean ven desol_12/04/18[/TD]
[TD] Tanya, Surname_25/12/18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Craig McDermott | Peter Jones|_10/11/13[/TD]
[TD]Surname Name 4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Vince_Surname_15/06/16[/TD]
[TD]Surname Name 5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eddy Murphy_23/10/18[/TD]
[TD]Surname Name 6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Surname Name 6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Objective is to search each cell of the column A, which has the record with date after 5th March 12 and match with each of the cell of Column B and Print matched with row number of Coumn B. As shown in Tab Results Expected[/TD]
[TD]David Surname_11/12/12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jean ven desol_12/04/18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Surname kenny_10/08/12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eddy Murphy_23/10/18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jean ven desol_12/04/18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Craig McDermott | Peter Jones|_10/11/13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Vince_Surname[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Result
[TABLE="width: 712"]
<tbody>[TR]
[TD]Rearranged Search Names and Date[/TD]
[TD]Date[/TD]
[TD]Search against this Coloumn[/TD]
[TD]Record 1D[/TD]
[TD]Date[/TD]
[TD]Record Status (if matched, print the row)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tanya Surname[/TD]
[TD]25/12/2018[/TD]
[TD]Names 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]David Surname[/TD]
[TD]11/12/2012[/TD]
[TD]Names 2 Surname[/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kenny Surname[/TD]
[TD]10/08/2012[/TD]
[TD]Surname Name 3[/TD]
[TD][/TD]
[TD][/TD]
[TD]Not available[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thomas Surname[/TD]
[TD]12/06/2019[/TD]
[TD]Name_Surname4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Not available[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jean ven desol[/TD]
[TD]12/04/2018[/TD]
[TD] Tanya, Surname_25/12/18[/TD]
[TD][/TD]
[TD][/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Craig McDermott[/TD]
[TD]10/11/2013[/TD]
[TD]Surname Name 4[/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Vince Surname[/TD]
[TD]15/06/2016[/TD]
[TD]Surname Name 5[/TD]
[TD][/TD]
[TD][/TD]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eddy Murphy[/TD]
[TD]23/10/2018[/TD]
[TD]Surname Name 6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]list continues[/TD]
[TD]List continues[/TD]
[TD]Surname Name 6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]David Surname_11/12/12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Jean ven desol_12/04/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Surname kenny_10/08/12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Eddy Murphy_23/10/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thanks in advance.[/TD]
[TD][/TD]
[TD]Jean ven desol_12/04/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Craig McDermott | Peter Jones|_10/11/13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Vince_Surname[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]