title: Search for all matching values in one column and if adjacent column contains "X" return "Y"
body: <p>I have a large data set that contains a column with an ID then sub ID's and then status of the sub ID.  FYI; a sub ID can have two statuses.  I would like a formula to look in Column A and find all matching values and if the status of any equals "x" then return a defined value.</p>
  
  <p>Example:</p>
  
  <pre><code>A        B      C
  1-001   0550    UD
  1-001   0550    DV
  1-001   0003    UD
  1-001   0001    UD
  1-001   1   
  1-003   0550    UD
  1-003   0003    UD
  1-003   0001    UD
  1-003   1   
  1-005   0550    UD
  1-005   0550    DV
  1-005   0027    UD
  1-005   0026    UD
  1-005   0024    UD
  1-005   0023    UD
  1-005   0017    UD
  1-005   0014    UD
  1-005   0012    UD
  1-005   0011    UD
  1-005   0003    UD
  1-005   0001    UD
  1-005   1   
  </code></pre>
  
  <p>I've tried </p>
  
  <pre><code>=IFERROR(INDEX($A$2:$A$7390, SMALL(IF(ISNUMBER(SEARCH(A9,$A$2:$A$7697)),MATCH(ROW($A$2:$A$7697),ROW($A$2:$A$7697))),ROW(A8))),"")
  </code></pre>
  
  <p>but that's not really what I need.....</p>