title: How to identify and bring cell from column X that contains all values from row Y?
body: <p>I´ve a long (+50k items) master file that contains names and addresses; all in one column:</p>
  <blockquote>
  <p>John Doe, TX - Houston</p>
  <p>Richard Gonzalez, TX - Lipscomb</p>
  <p>.......</p>
  </blockquote>
  <p>Now, I´ve a much shorter list of people I need to find there.
  I´ve name in column B, surname in C, state in D, county in E, but for many of them, I´ve partial information (mainly no address), and I need to find if they´re in my master file or not.
  It may be that I´ve:</p>
  <blockquote>
  <p>John --------------- Doe -----------------  TX</p>
  </blockquote>
  <p>But no County, and there may be multiple matches in my master file so I need to bring them all.</p>
  <p>I tried this formula, which gives me true if all the values I´m looking for are indeed in a specific cell:</p>
  <pre><code>=+AND(ISNUMBER(SEARCH(B1,A:A)),(ISNUMBER(SEARCH(C1,A:A))),(ISNUMBER(SEARCH(D1,A:A))),(ISNUMBER(SEARCH(E1,A:A))))
  </code></pre>
  <p>That was a great advance, as now I know which ones I´ll be able to find, but I would like the formula to tell me in which cells can I find them, and bring me those cell contents next to my search if possible too.</p>
  <p>How should I do this?
  Any help or hint would be much appreciated!</p>
  <p>Edit:</p>
  <p><a href="https://i.stack.imgur.com/ts4NG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ts4NG.png" alt="enter image description here" /></a></p>