title: How do I compare 3+ lists/columns of data to identify multiple occurrences (to make a matrix)?
body: <p>I am trying to create a matrix in Excel and I have struggled with coming up with a formula that works. I understand that it is easy to compare 2 lists (but not 4+ lists like I have)
  This matrix is to identify whether an occurrence happens.</p>
  <p><em>Beginning Dataset:</em></p>
  <p>Buidling1 Building2 Building3 Building4 <br/>
  NX1 ---- NX2 ---- NX1 ----  NX1 <br/>
  NX3 ---- NX3 ---- NX3 ----  NX2 <br/>
  (Blank)---- NX4 ---- (Blank) ---- NX3 <br/></p>
  <p><em>Example of the desired outcome (Option1):</em></p>
  <p>Building1 Building2 Building3 Building4 <br/>
  NX1----(blank)----NX1----NX1 <br/>
  (Blank)----NX2----(Blank)----NX2 <br/>
  NX3-----NX3-----NX3-----NX3 <br/>
  (Blank)----(Blank)----(Blank)----(Blank) <br/></p>
  <p><em>Example of the desired outcome (Option2):</em></p>
  <p>----- Build1 Build2 Build3 Build4 <br/>
  NX1 Yes-----(blank)-----Yes-----Yes <br/>
  NX2 (Bla)----Yes----(Bla)----Yes <br/>
  NX3 Yes------Yes------Yes------Yes <br/>
  NX4 (Bla)----NX4----(Bla)----(Bla) <br/></p>
  <p>Either option1 or option2 works fine.</p>
  <p>Does anyone know an appropriate way for this to be done in excel or powerquery?</p>
  <p>I have tried v-lookups and indexing.</p>