title: Determine if name in list A has perfect match, partial match, or is not found in list B?
body: <p>In Excel, I have two columns of property names. I need to determine if a name in Column A has a complete match, a partial match or no match in Column B.  </p>
  
  <p>Something beyond setting this up that is confusing me as well is what if there are multiple partial matches - I don't think it is reasonable to complicate this with a "best match" component, but I'm not sure how to deal with this part.</p>
  
  <p>How can this be done?</p>