Hmm, you're talking about fuzzy matching here I think. Unfortunately, I don't know of a way to do that directly in Tableau. You're probably going to need to look at doing this within your data prep. Various data prep and ETL tools, such as Alteryx, should be able to do this. Or you could write some code.
Are you able to attach original excel file?
This requires modifying connection which needs original excel? file.
I was able to recreate your match table using a combination of
self-joins and calculated fields, but this will likely show poor performance
with large datasets. Better performance, as Ken stated above, will
likely be achieved with data prep.
Nonetheless, please see workbook v2018.1 attached in the Forum Thread.
Can explain further, if desired.