I have 2 tables and i want to compare their data in a sheet but their primary keys is their name but in the other table the name is longer and sometime does not contain upper case.
Name
Year
Francis
1995
Denis
1985
Jean
1975
Name
Age
Francis Lalan
22
denis Rousseau
39
If i want to have a table like this, is there any partial matching way to do it ?
