Need Function that can identify spelling mistakes in one list compared to another list

The easiest solution for this is to use 'fuzzy matching' logic with Power Query in Excel.
Takes a little homework to understand if you are new to Power Query, but its very quick/powerful. A guide here: https://support.microsoft.com/en-us/...4-bd3962b90649

I've mocked up an example of this in the attached, by taking the following steps
1) Created a connection called 'CheckNames' from your Column A
2) Created a connection called 'ProperNames' from your Column C
3) Merged the two queries with the following parameters
- Left table = CheckNames
- Right table = ProperNames
- Fuzzy match, Left Outer Join (every item on 'left' table has a row), Number of matches = 1 (one response per row), Threshold = 0 (show best guesses, even if they are terrible)

Hope that gets a result similar to what you are looking for. You can play around with the 'Threshold' parameter until you get sensible looking outcomes