title: VLOOKUP for any member of a comma-separated list in Excel
body: <p>If I have an array of values each true or false like so:</p>
  
  <p><kbd><code>Foo  </code></kbd><kbd><code>TRUE </code></kbd><br>
  <kbd><code>Bar  </code></kbd><kbd><code>FALSE</code></kbd><br>
  <kbd><code>Spam </code></kbd><kbd><code>FALSE</code></kbd><br>
  <kbd><code>Egg  </code></kbd><kbd><code>TRUE </code></kbd><br>
  <kbd><code>Chips</code></kbd><kbd><code>FALSE</code></kbd><br></p>
  
  <p>And cells containing a comma-separated list like so:</p>
  
  <p><kbd><code>Foo,Spam,Chips</code></kbd></p>
  
  <p>I want a function that will return <code>TRUE</code> if any of the values in the comma-separated list have a value of <code>TRUE</code> in the table, like so:</p>
  
  <p><kbd><code>Foo,Spam,Chips</code></kbd><kbd><code>TRUE </code></kbd> as <code>Foo</code> is <code>TRUE</code>
  <br>
  <kbd><code>Bar,Spam      </code></kbd><kbd><code>FALSE</code></kbd> as neither <code>Bar</code> not <code>Spam</code> are <code>TRUE</code>
  <br>
  <kbd><code>Egg,Foo       </code></kbd><kbd><code>TRUE </code></kbd> both <code>Foo</code> and <code>Egg</code> are <code>TRUE</code>, function works with list in any order</p>
  
  <p>Essentially, I want to be able to <code>VLOOKUP</code> on every member of a comma-separated list of arbitrary length, and return the logical OR on the results. I assume I'll need to write a macro to do this. My VBA is a little weak though - where would I begin?</p>