Extracting Data Based on Yes or No Condition

[leowyatt]

Hi there,

I am looking for a solution to my problem and I hope one of you guys can help me out. I am trying to pull data from a "main" sheet based on the condition of yes or no. If the cell in the list equals "Y" then that data is pulled. If it equals "N" then it isn't. Here is an example:

"Main" Sheet

Sites Metric 1 Metric 2 Metric 3 List 1 List 2 List 3 List 4
http://www.site1.com 96.99 100 7.98 Y Y Y Y
http://www.site2.com 91.83 96.8 6.71 Y N N N
http://www.site3.com 88.45 96.11 6.03 Y Y Y Y
http://www.site4.com 90.58 98.48 7 N N N N
http://www.site5.com 90.24 96.51 6.43 N Y Y Y
http://www.site6.com 74.74 96.19 6.07 Y Y N Y
http://www.site7.com 65.53 93.46 5.2 N N Y N
http://www.site8.com 82.81 95.45 5.82 Y Y Y Y
http://www.site9.com 60.19 81.11 3.95 N Y Y Y
http://www.site10.com 94.8 93.68 6.88 Y N N Y

"List 1" Sheet

Sites Metric 1 Metric 2 Metric 3

"List 2" Sheet

Sites Metric 1 Metric 2 Metric 3

"List 3" Sheet

Sites Metric 1 Metric 2 Metric 3


I need the data to be pulled across based yes or no (or true or false)

So.. site1.com would be displayed in all 4 list tabs
site2.com would only be displaying in list 1 tab
site3.com would be displayed in all 4 list tabs
site4.com would be displayed in none of the tabs
and so on.....

Please help as this is really causing me a headache...

I have attached 2 example sheets (I have 2010 version so I have xlsx... but saved as older one too .xls)

Thank you