title: How to MATCH text with a wildcard in the target matrix
body: <p>I want to assign a transaction type to a list of credit card transactions. The type depends on the description of each transaction, which is a text value. I use <code>INDEX</code> <code>MATCH</code> to lookup the type in a description index table which maps from transaction descriptions to types.</p>
  
  <p>Here is the problem: I want to avoid a long list of very similar entries in the description index table. I already have more than ten entries that contain the substring "amazon". Therefore, I thought about using wildcards in the <code>MATCH</code> so that all transactions that contain the substring "amazon" (or similar) are mapped to the same type. Unfortunately, <code>MATCH</code> supports wildcards only in the search value, not in the target matrix. Therefore it seems to be impossible to maintain a description index table that uses wildcard matching patterns.</p>
  
  <p>Can this be done? </p>
  
  <p>Consider the following sample tables. I want to match <code>Description</code> against <code>Pattern</code> to find the <code>Type</code>.</p>
  
  <p><strong>Transaction Table</strong></p>
  
  <pre><code>| Description       | Amount |
  |-------------------|--------|
  |Amazon Merchant XY | 100.00 |
  |Amazon online //&gt;  |  89.99 |
  |Amazon.com         |  32.64 |
  </code></pre>
  
  <p><strong>Lookup Table</strong></p>
  
  <pre><code>| Pattern   | Type         |
  |-----------|--------------|
  |*amazon*   |Shoping       |
  |*itunes*   |Entertainment |
  </code></pre>