Cross checking data from two different systems but they export in different formats - how to marry them up?

I have a table with two sets of data exported from two different systems that I need to reconcile - names and values. Trouble is they export in different formats so I'm needing partial look-up? The lists are also not exact duplicates so there are names on one that don't appear on the other. Once the names have been matched up I then need to cross check the value to isolate any variances. So two formulas for two columns.

thanks