Dear all,

I have a table with 4 columns. From the following table, I want to see the rows that have:

1. year 2010
2. color red
3. value over 100

-------A--------B-------C-------D
name-------year------color----value
1-chris-----2010-----red------120
2-bob-------2011-----blue----140
3-nik--------2010-----red-----140
4-aron------2010-----red-------30

I want that excel shows me those rows on an other part of the spreadsheet, including the corresponding names from column A.

This means, I would like to see the following result on another part of my spreadsheet:
chris---2010---red---120
nik----2010----red---140

any idea how this could work??