title: Flagging all rows in an order that contain a particular item
body: <p>I have a detailed list of all items in a handful of orders.  Each order has a unique identifier that appears in each relevant row.  I need a formula that can pull column C if any row in the order contains item X or column D if none of the rows in that order contain item X.  How can I do this?  I am happy to do this either directly in Excel or PowerPivot.</p>
  
  <p>Thank you!</p>