title: Doing a reverse MATCH lookup in Excel
body: <p>I have two tables.</p>
  
  <p><code>Data</code> and <code>GroupLookup</code></p>
  
  <p><code>Data</code> contains Two fields <code>Text</code> and <code>Group</code>, GroupLookup contains <code>LookupValue</code> and <code>Group</code></p>
  
  <p>The idea is i wan't to use a formula for <code>Data[Group]</code> to find in <code>Data[@Text]</code> i.e. a row, a wildcard word from <code>GroupLookup[LookupValue]</code> and get <code>GroupLookup[Group]</code> into <code>Data[Group]</code></p>
  
  <p>For example i have a text called "Banjo Pizza 1231" in my <code>Data[Text]</code> i want to lookup "pizza" and then apply the <code>GroupLookup[Group]</code> whos value would be "Pizza Expense".</p>
  
  <p>I've tried a formula like </p>
  
  <pre><code>=INDEX(GroupLookup[Group];MATCH("*"&amp;[@Text]&amp;"*";GroupLookup[LookupValue];0))
  </code></pre>
  
  <p>But it do it the wrong way. It applies the Text to the LookupValue. E.g "BC" in Text would match "ABC" in LookupValue. I want it the otherway around.</p>