title: Google Spreadsheet MATCH for multiple strings
body: <p>I am trying to find the formula to <code>MATCH()</code> for multiple strings. Normally I would just use the wildcard like <code>MATCH("String1*String2";A:A)</code> where <code>String1</code> and <code>String2</code> are two strings to be found in one cell of column A but these two could be separated with any other string but the wildcard does not work in this case.</p>
  
  <p>A more complex version of the problem is when <code>String1</code> and <code>String2</code> could occur in any order inside one cell.</p>