title: How Look for a value and bring next row, but not repeat?
body: <p>I am trying to create an ordering file, it has 2 tabs, one with the official order form, and the next tab with the items they can order. I want to automatize the order tab, so i added check boxes next to each item and linked to a row next to it where it shows &quot;TRUE&quot; if checked and &quot;FALSE&quot; if not checked. I have also added another row with an if formula to simply look for that cell and if &quot;True&quot; show &quot;X&quot;.</p>
  <p>My question is, how can i write a formula to look for all items marked with &quot;X&quot; and automatically fill my order? I want to add the formula to all rows on the order form, so if they select 10 items they would show (but not repeat), and if they only selected one it would show only 1.</p>
  <p>In the pic below, if they checked the box it would show on the other sheet with quantity and the CASE UPC</p>
  <p>In the First picture shows where they would make the selection</p>
  <p><img src="https://i.stack.imgur.com/HKx1U.png" alt="" />]<a href="https://i.stack.imgur.com/HKx1U.png" rel="nofollow noreferrer">1</a></p>
  <p>In the second picture shows where the formula would bring the qty and UPC Case code</p>
  <p><a href="https://i.stack.imgur.com/CEkyQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CEkyQ.png" alt="" /></a></p>
  <p>I am trying to do something like VLOOKUP, but VLOOKUP would stop in the first match and repeat it. Thank You so much!</p>