Using "Fuzzy Lookup" to compare 2 columns... on Office for MAC

[carlcryptocurrency]

There are great plug-ins for Fuzzy Lookups on Windows machines but I work in a Mac office. I am trying to:

• I have 2 lists: a Lead List of companies and an event Attendee List
• I want to compare these lists but there will be spelling inconsistencies between the 2 lists (e.g. - Coca Cola -vs- The Coca Cola Bottling Company)

As a novice, I can imagine using a xLOOKUP but that is not scalable for the hundreds of records I want to run through this formula/function. How can I fuzzy compare these lists against each other where:

• Col A = Lead List
• Col B = Attendee List
• Col C = "Lead is attending event" adjacent to the attendee list/cell if there is a fuzzy match

Is there a magical fuzzy function or should we consider "any 8-char string" match between a record [in the Lead List] and the Attendee List?