title: Matching partial text at the end of a string in Google Sheets
body: <p>I have <a href="https://pastebin.com/kyAmzER1" rel="nofollow noreferrer">data in a Google spreadsheet</a> that I need to match to their standard country codes. For e.g. <code>Greater Chicago Area</code> would be <code>US</code>. For all cells that need to be marked US, they seem to end with the word <code>Area</code>. For all other countries, they end with their country names.<br />
  I tried the following formula but it does not seem to work -</p>
  <p><code>=IFS(ISNUMBER(FIND(&quot;Area&quot;,A64)), &quot;US&quot;, ISNUMBER(FIND(&quot;*United Kingdom&quot;,A64)), &quot;UK&quot;)</code>.</p>
  <p>Is there a way to match partial text at the end of the string?</p>