title: Need to understand fomula re: excel search for a string in a table and return string if true
body: <p>I've adapted this solution from a couple of years ago:</p>
  
  <pre><code>=LOOKUP(2^15,FIND(Keywords,A2),Categories)
  </code></pre>
  
  <p>I use this for searching within a description field for keywords in a named list, in order to return a corresponding category from an adjacent named list.</p>
  
  <p>However I do not understand the significance of 2^15. Can someone explain?</p>
  
  <p>Also it's unclear in what order the search operates. If two keyword options were "check" and "deposit," and they were assigned to different categories, but both appeared in the same description field cell, how do I know which will be found first? Is it placement in the string, or order in the list?</p>