title: Extract data from two columns of one worksheet to another depending on presence of character in third column of a worksheet
body: <p>I am looking for some help with a formula. On one worksheet, I have data set up similar to:</p>
  
  <pre>
     A        B            C        D        E
  1                      Test1    Test2    Test3
  2 ID     Name      
  3 T01    Confucius       X       
  4 T02    Newton          X
  5 T03    Enstein                  X
  6 T04    Plato                    X        X
  7 T05    Da Vinci                          X </pre>
  
  <p>It is similar to comparison of different products against set of features.</p>
  
  <p>What I would like is, on a separate worksheet, when a test name (i.e. row1) is selected, information from column A and column B is returned ONLY if there is a check mark in the column for the respective test selected. In other words, if on a separate worksheet, I select <code>Test3</code>, then <code>T04 Plato</code> and <code>T05 Da Vinci</code> are returned. I would like this dynamic as my data spreadsheet will continue to grow with new IDs/Names and test(x).</p>
  
  <p>I am open to formulaic or filter-type solutions.</p>