title: Excel building table with two instances
body: <p>So im building a table to show people that are assigned to work.</p>
  
  <p>I build the names using a list thats stored in a datasheet named lists then depending on whether or not they've got a flag set to one in the master table the row is added to the assigned table.</p>
  
  <p>However I am running into a problem I cannot seem to fix in that a person may be assigned to two projects.There is only one instance of their name in the assigned table and the search only returns the first row found in the master table. Meaning that if someone is assigned to two projects I can only see one in my assigned table.</p>
  
  <p>Is there anyway I can get the list to show all of the projects one user is assigned to? I was thinking about populating the names from the master sheet where the flag is set to 1 would this work?</p>
  
  <p>Any insight would be much appreciated, Thanks in advance</p>
  
  <p>EDIT:</p>
  
  <ul>
  <li>Assigned table contains a row relating to a name from master table where flag=1</li>
  <li>Master table could have two instances of same name with flag=1</li>
  <li>Using Match and index only returns first instance of flag=1 found</li>
  <li>Therefore if a person is assigned to two projects only one will show as there is only one row with there name</li>
  </ul>
  
  <p>At the moment I'm using this formula</p>
  
  <pre><code>=IFERROR(INDEX('Master Data'!$D$2:$D$153,MATCH(1,(B23='Master Data'!$J$2:$J$153)*('Master Data'!$W$2:$W$153=1),FALSE)),"")
  </code></pre>
  
  <ul>
  <li>Where D = Data required</li>
  <li>B23= persons name in assigned</li>
  <li>J = persons name in master</li>
  <li>W = flag for assigned</li>
  </ul>