Return Value from column based on header value

Morning all,

Right then. I'm having trouble working this one out:

Cells A3:A500 contain product numbers, e.g. 1001, 1002, 1003 etc.. etc...
Cells G2:N2 are column headers, e.g. North2011, South2011, North2012, South2012 etc... etc...
Cell F2 is a lookup that will return a year, e.g. 2011, 2012, 2013 etc... etc...

Against each product is a "yes" if it was sold in the north or south region for each year. This could be both north and south, one or the other or none at all.

What I would like is a formula in cells E3:E500 that looks at the year in cell F2 and if there is a "yes" in either the North or South for that year to return "yes" otherwise blank.

Apologies for the long description but I am unable to upload a sample document due to firewalls.

Thanks for any help in advance!

SA

Guys, thanks for the responses - which both work perfectly, by-the-way. I think I'm going to opt for Ace_XL's solution just on the basis that it's not an array formula which I'm worried could slow down an already large spreadsheet.

Kudos, chaps. I'm more than happy to add to your 'reputation' points.

SA

Thanks again for your time, and expertise - really is very much appreciated.