title: Multiple criteria search with IDs
body: <p>I don't usually come to Stack Overflow empty handed (without having VBA code) but I honestly don't know how to get the following idea to work.</p>
  <p>I'm trying to build a raw data <strong>search engine</strong> which would work by setting 3 criteria in a box/cells on the side of the spreadsheet. The raw data contains sets of IDs in column (A) with various lengths, the search should run once for every set of IDs and look up whether it can match CRITERIA 1 &amp; CRITERIA 2 to column (B) and whether it can match CRITERIA 3 to column (C).</p>
  <p>If all three criteria match for one set of IDs then search engine should return &quot;MATCH&quot; in column (D)</p>
  <p><a href="https://i.stack.imgur.com/TqGVq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TqGVq.png" alt="see excel example here" /></a></p>
  <p>Note note that ultimately the macro should be able to run the search on around 50'000 rows of data and for up to 5 criteria!</p>
  <p>How can I start, or what functions should I use?</p>