title: Trouble with fuzzy matching columns
body: <p>We have a long list of organizations that we are trying to match to another long list of organizations. Normally, I would just use an index/match formula to match the 2 columns together. However, they both utilize organization names and the spelling can vary mildly.</p>
  <p>For example, one column might refer to Organization A as &quot;Tanner Health&quot; and another might refer to it as &quot;Tanner Healthcare&quot;. Another example, one column might refer to Organization B as &quot;The Tanner Health Institute&quot; and another might refer to it as &quot;Tanner Health Institute&quot;. There are countless examples, but the idea is that we want to try and get the closest possible match between the 2 columns.</p>
  <p>It is totally possible that a Organization in column 1 might not exist in column 2, in which case, we don't want it to return anything.</p>
  <p>If it helps at all, we also have information about each organizations state and zip code. So, I considered an array formula that matches Zip code, State, and then does the best fuzzy match to the available options.</p>
  <p>I am struggling to find a formula that can do a fuzzy match of the 2 columns, and am looking for suggestions on the best way to approach this problem.</p>