How to simply match two cells that have a letter different, for compliance checking

This seems like such an easy solve, but Im just brain blanking on it.

Apologies on the picture, people say enter these things as an excel sheet and I don't see that option.

Currently my =MATCH(A1291,Sheet4!$D$2:$D$1271,1) is giving wild results and counting people that I double check and they haven't finished the course

What I need is a simple (yes or no), it could be 1's or 0's in a cell... but as you can see I have 1300ish people to double check, which that number is growing quickly, hence why I need a solution before it gets away from me.

Both lists come from two columns each and I had to Concat it into one cell, thinking it would be easier. is this the issue?

IS anyone able to help?

You could use Fuzzy Match within Power Query.

• Put your values into an Excel table - highlight the data and press Ctrl+T.

• Click Data > From Table/Range (this will create a table from your data if you haven't already),

• In the Window that pops up click Advanced Editor.

• Replace the script in the advanced editor with this:

  let
      Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    ChangeDataType = Table.TransformColumnTypes(Source,{{"Registered Name", type text}, {"Course Completed", type text}}),
  
    Register = Table.SelectColumns(ChangeDataType,{"Registered Name"}),
    Completed = Table.SelectColumns(ChangeDataType,{"Course Completed"}),
  
    FuzzyMatch = Table.FuzzyNestedJoin(Register, {"Registered Name"}, Completed, {"Course Completed"}, "Merged", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true, Threshold=0.75]),
    ExpandTable = Table.ExpandTableColumn(FuzzyMatch, "Merged", {"Course Completed"}, {"Course Completed"}),
      IsMatch = Table.AddColumn(ExpandTable, "Match", each if [Course Completed]=null then Logical.FromText("false") else Logical.FromText("true"), type logical)
  in 
    IsMatch
  

• Click Done at the bottom of the Advanced Editor.

• Click Close & Load > Close & Load To
  

• Select Table and where you want to load it to.
  

• This gave me the table in columns D:F based off the table in column A:B:
  

You may need to play around with the 0.75 threshold value in the merge and it might still give some problematic results, but that's fuzzy matching for you - "Slockoverstow" doesn't return a match, but "Slack Overstow" will.