title: How to select values spanning across 3 columns in Excel?
body: <pre><code>column 1   |  column 2  |  column 3   |   column 4(need result like below)
  
  Oscar.won? |  Movies1   |  Movies2    |Oscar Won Movies Of Column 3
  
  0            Godzilla    SPIDERMAN 3      Avatar
  0            Spectre     Constantine      LOTR  
  1            Avatar      Skyfall          Slumdog.M
  1            Slumdog.M   Avatar
  0            Hercules    LOTR
  1            LOTR        Superbad
  1         Some film     Slumdog.M
  0         Some film     Some film
  1         Some film     Some film
  </code></pre>
  
  <p>This table is in Excel 2016.Column 1 and 2 are related and has about 1 million rows.It has all the Oscar nominated films from 1927-2016. The value 1 in column 1 specifies that the corresponding film in column 2 has won an Oscar and 0 means it hasn't. column 3 has 5000 rows,is unrelated to columns 1 and 2. It has a mix of films which are all in column 2. 
  Now,here is my question. I want to select the Oscar won movies of column 3. So basically I need to find all the column 3 films in column 2, then select only the ones which has won an Oscar and tabulate column 4.</p>